开发者

passing parameters to a stored Proc accepting in parameter of type XML type from vb.net

I have a storedproc accepts parameters in XMLtype as

CREATE OR REPLACE PROCEDURE GetDetails(
                            p_para  IN  XMLTYPE,

i have to pass 4 parameters to this proc how to do this?

i am passing param as db.Parameters("p1", Oracle.DataAccess.Client.OracleDbType.Varchar2, _ ' LN.Length, CObj(LN), Data.ParameterDirection.Input)

and tried this db.Parameters("p1", 开发者_运维问答Oracle.DataAccess.Client.OracleDbType.XMLType, _ ' LN.Length, CObj(LN), Data.ParameterDirection.Input)


create a XMLDoc object and add nodes to it ..the nodes name should be same as parameters name in the procedure and db.parameters("p1", Oracle.DataAccess.Client.OracleDbType.xmltype,xmldoc.outerxml.length, cobj(xmldoc.outerxml),Data.ParameterDirection.Input)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜