Hi,
I am making a call to the Oracle Stored Procedure from ASP.Net which is as below:
CREATE OR REPLACE PROCEDURE procSPRPTQTCTORGSTRUCT(strOrgDefIDs IN VARCHAR2 DEFAULT '0',strOrgStructIDs IN VARCHAR2 DEFAULT '0',RC1 OUT Omwb_emulation.globalPkg.RCT1)ASBEGIN BODY; --BODY is too long so its not shown here. END;END procSPRPTQTCTORGSTRUCT;/
The SP is outputting the Resultset correctly when called from TOAD But when called from ASP.Net I am getting the error;
Getting ORA-00911: invalid character error when trying to call a Oracle SP
I doubt that there is something wrong syntactically in the way I am passing the parameters to the procedures.
The erroneous syntax I am using is;
Dim cmd As OracleCommand = New OracleCommand({call GLOBALPKG.procSPRPTQTCTORGSTRUCT(0,0,{resultset 100,RC1})}, cnn)
Please tell me how to call this procedure using ADO.Net in ASP.Net.Please give me the exact syntax of calling the Procedure and populating the same in a Dataset.
Please help me its very urgent................
Regards,Mahesh.N