469,603 Members | 2,285 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

Oracle Calling A Stored Procedure

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
1 1607
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.

Similar topics

reply views Thread by stephane.traumat | last post: by
1 post views Thread by Jason Leiser | last post: by
2 posts views Thread by paddy_nyr | last post: by
1 post views Thread by burtonl | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.