Bola,
I have received these errors many times. They have always been one of two
things.
1) The parameter property for 'On Empty Parameter' is set to 'Exclude'
instead of send 'NULL'. So, if I am setting a string parameter to be '' or
any other type of parameter to null, the parameter is excluded instead of
being sent as null. Hence a mismatch in the number of parameters.
2) My types in ND and Oracle do not match. Verify your Oracle types again.
Then check in the studio to make sure that your types match. Then, check in
your code.
Finally, turn RDMS debugging on high. In this way, you will be able to see
exactly what is being sent to your stored procedure.
Bryan
-----Original Message-----
From: Bola Taylor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 29, 1999 5:23 AM
To: [EMAIL PROTECTED]
Subject: Re: [ND] oracle 7.3.4 stored procedures from an ND4.1.3 page
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]
*****************************************************************************
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized.
If you are not the intended recipient, any disclosure, copying, distribution
or any action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful. When addressed to our clients any opinions or advice
contained in this email are subject to the terms and conditions expressed in
the governing KPMG client engagement letter.
*****************************************************************************
_________________________________________________________________________
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]
