Calling Add/Update Oracle Stored Procedures using OracleClient

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
Back
Top