Help: Calling Oracle SP using OLEDB.net

[Guest]

Hi,

I am trying to call an oracle stored proc using the OLEDB.net provider.

The connection string is and command is dynamic. There are 2 textboxes which
take the parameters as the app is must be able to handle any (almost)
database, works with sql server but with oracle I get an "Invalid SQL
Statement" error.

There is nothing wrong with the procedures syntax. Its been running for
months.

Any ideas? Does an Oracle procedure need to be called differently?

Any help will be GREATLY appreciated.

Regards

Emilio

 

[mboizeau]

Hi Emilio, look at

http://oraclevsmicrosoft.blogspot.com/2005/04/call-oracle-stored-proc-with-oledb-net.html

I've just put a sample code on how I call a stored proc with an
OLEDBCommand object

If you have questions, just put a comment on the post

hope this helps

http://oraclevsmicrosoft.blogspot.com

 

[Paul Clement]

¤ Hi,
¤
¤ I am trying to call an oracle stored proc using the OLEDB.net provider.
¤
¤ The connection string is and command is dynamic. There are 2 textboxes which
¤ take the parameters as the app is must be able to handle any (almost)
¤ database, works with sql server but with oracle I get an "Invalid SQL
¤ Statement" error.
¤
¤ There is nothing wrong with the procedures syntax. Its been running for
¤ months.
¤
¤ Any ideas? Does an Oracle procedure need to be called differently?
¤
¤ Any help will be GREATLY appreciated.
¤
¤ Regards
¤
¤ Emilio

Could you post some code so we can see what you are doing (including the SQL statement)?


Paul
~~~~
Microsoft MVP (Visual Basic)