Help: Calling Oracle SP using OLEDB.net

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
¤ 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)
 
Back
Top