Problems in Calling Oracle Stored Procedures using .Net

Sep 15 2005 10:52 AM

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)
AS
BEGIN
  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