Hi,
I think you have set the onEmptyValue property of one of the
datafields(of the dataobject bound tothe procedure) to
"Exclude". In case of a null value this parameter will not be passed
to the stored proc and hence the error. Hope it helps.
kiran
Bola Taylor wrote:
> 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]
begin:vcard
n:H.N;Kiran H.N
tel;work:6678355 Ext 263,259
x-mozilla-html:FALSE
org:IT Solutions (India) Pvt Ltd.,
adr:;;;Bangalore;Karnataka;;India
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Software Engineer
x-mozilla-cpt:;32640
fn:Kiran H.N
end:vcard
