What is the proper odbc command for calling Oracle stored procedure with parameters from .Net?
- by Hamish Grubijan
In the case of MSFT SQL Server 08, it is:
odbcCommand = new OdbcCommand("{call " + SP_NAME + " (?,?,?,?,?,?,?) }", odbcConn);
When I try to do the same thing for Oracle, I get:
OdbcException: ERROR [HYC00] [Oracle][ODBC]Optional feature not implemented.
Feel free to ask for clarification, and please help. I am using .Net 3.5, SQL Server 08, and Oracle 11g_home1.
P.S. The Oracle stored procedure does have some 3 more parameters, but I believe I am handling this in my code.