By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,609 Members | 3,812 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,609 IT Pros & Developers. It's quick & easy.

Oracle Calling A Stored Procedure

P: n/a
Hello, I have an update stored procedure which is in a package. In my code I
create all of the paramters and then call the stored procedure with
"ExecuteNonQuery()" method of the command. The Command oject I am using is
an "IDbCommand" rather then the OracleCommand object.

The call always fails which and error message indicating that a conversion
error between character and Numeric values. If I look at the database, the
procedure clearly has worked from a database perspective. It sounds like
some problem with MS attempting to return the "int" of the method of the
ExecuteNonQuery() method.

If I instead create a datareader with the same command above, the procedure
works just fine, I can then read my parameters and all is right with the
world.

Why can't I use the "ExecuteNonQuery" method of the command with Oracle?
What do I need to do differently?

Thanks in advance for your assistance!!!
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Show your code where you set the parameter list, and of the stored proc also

Jeff
"Jim Heavey" <Ji*******@discussions.microsoft.com> wrote in message
news:7A**********************************@microsof t.com...
Hello, I have an update stored procedure which is in a package. In my code I create all of the paramters and then call the stored procedure with
"ExecuteNonQuery()" method of the command. The Command oject I am using is an "IDbCommand" rather then the OracleCommand object.

The call always fails which and error message indicating that a conversion
error between character and Numeric values. If I look at the database, the procedure clearly has worked from a database perspective. It sounds like
some problem with MS attempting to return the "int" of the method of the
ExecuteNonQuery() method.

If I instead create a datareader with the same command above, the procedure works just fine, I can then read my parameters and all is right with the
world.

Why can't I use the "ExecuteNonQuery" method of the command with Oracle?
What do I need to do differently?

Thanks in advance for your assistance!!!

Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.