Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting ORA-00911: invalid character error when trying to call a Oracle SP

454414Sep 15 2005 — edited Sep 15 2005
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2005
Added on Sep 15 2005
1 comment
858 views