What is the proper odbc command for calling Oracle stored procedure with parameters from .Net?
Posted
by Hamish Grubijan
on Stack Overflow
See other posts from Stack Overflow
or by Hamish Grubijan
Published on 2010-04-21T23:13:07Z
Indexed on
2010/04/21
23:53 UTC
Read the original article
Hit count: 245
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.
© Stack Overflow or respective owner
