Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stored Procedures Error in C#

249496Jun 25 2003 — edited Jun 25 2003
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 23 2003
Added on Jun 25 2003
4 comments
608 views