I'm developping a .NET application that interact with an Oracle 8 database.
I've some problem passing parameters to a query:
If I try SELECT DATA FROM TABLE WHERE KEY=&AAA in SQL+ it works fine, oracle ask me for the parameter and it returns data.
If I connect directly with the connectiontype Oracle it also works (but I've other problems)
If I connect with connectiontype OLEDB, I creat a command with the same SQL string, and I add a parameter &aaa with his value I obtain ORA-01008 Error.
What is the right sintax for passing parameters to a query with oledb connectiontype? Stevie B. Gibson
I've some problem passing parameters to a query:
If I try SELECT DATA FROM TABLE WHERE KEY=&AAA in SQL+ it works fine, oracle ask me for the parameter and it returns data.
If I connect directly with the connectiontype Oracle it also works (but I've other problems)
If I connect with connectiontype OLEDB, I creat a command with the same SQL string, and I add a parameter &aaa with his value I obtain ORA-01008 Error.
What is the right sintax for passing parameters to a query with oledb connectiontype? Stevie B. Gibson