Joe
I have been trying to call a stored proc with the following code but it does not work.
can you help
Thanx
Bola
[EMAIL PROTECTED] wrote:
>We are calling an oracle stored procedure with 3 IN and 1 OUT arguments from one
of our NetDynamics pages. The >procedure will work fine several times and
then
fail and then work fine again. The arguments to the stored procedure are
>written to the Netdynamics log file just before the call to the stored procedure.
>The first thing the stored procedure does
>is write a file with the arguments. When the failure occurs, the Netdynamics log
>file has the arguments, but the file
>written from the oracle stored procedure does not. When the error occurs, the
>Netdynamics log file has the following
>error message:
>
>DSRdbmsService:c:922884777681:w:922884784068: Error message [SERVERERROR] Error
>from Server: ORA-06550:
> line 2, column 1: PLS-00306: wrong number or types of arguments in call to 'CHKMONTH'
>ORA-06550: line 2, column 1:
>PL/SQL: Statement ignored
>
>We are guessing that the arguments are being corrupted. Has anyone had an experience
>like this?
>
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
