Calling Add/Update Oracle Stored Procedures using OracleClient

G

Guest

We just upgraded to .Net Framework 1.1 from 1.0 and updated our OLEDB Adapter to System.Data.OracleClient. We are using Oracle 9i as the database. Everything else seems to work fine but when we call Add/Update Stored Procedures we get the Oracle-Error ORA-06550 Wrong Number of types of arguments in the call to "Stored Procedure Name" Pl/SQl statement ignored

The same SPs were working fine with .Net 1.0 and OlEDb Adapter. Can someone throw some light on how to fix this problem

Thanks
 
G

Guest

Figured this out.

You have to pass the paramater size as well as direction in order to make your call to the SP work. I have to update 5000 lines of code to make it compatible with OracleClient Adapter Now:=\.

Arif
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use a datareader against an oracle stored procedure 2
Oracle error when i use System.Data.OracleClient 1.0.5000.0 3
Oracle 10g and OracleClient .Net 1.0/1.1 6
Oracle Stored Procs with Parameters 3
Returning CURSORS from ORACLE STORED FUNCTIONS 4
date from c# to oracle 1
Oracle Parameter goes missing 2
Accessing Oracle 9i Stored Procedures Using ADO.NET 3

Top