Stored Procedures Error in C#
249496Jun 25 2003 — edited Jun 25 2003I hope there is someone that can help me with this little problem. I have a simple procedure that take five arguments and it doesn't work! Here is the error that I get:
Unhandled Exception: System.Data.Odbc.OdbcException: ERROR [HYC00] [Oracle][ODBC
]Optional feature not implemented.
at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE
hType, RETCODE retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior,
String method)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at UsageServiceLib.LabComputer.updateDB()
at test.Class1.Main(String[] args) in c:\documents and settings\dann\my docum
ents\visual studio projects\test\class1.cs:line 31
Here is a snippet of code that shows how I am calling the stored procedure:
OdbcCommand dbSqlCom = new OdbcCommand("{call updatelabuse(?, ?, ?, ?, ?)}", dbConn);
dbSqlCom.CommandType = CommandType.StoredProcedure;
dbSqlCom.Parameters.Add("V_IPADDR", OdbcType.VarChar);
dbSqlCom.Parameters["V_IPADDR"].Value = machIp;
dbSqlCom.Parameters["V_IPADDR"].Direction = ParameterDirection.Input;
And I continue to do the parameters like the above.
Any help would be great.
Thanks
Ormy