Assuming you are using a dataObject, couple of things to check on:
1. Make sure that the number and types of parameters for the data object
match what the SP expects.
2. Make sure that each DataField in the DataObject has 'onEmptyValue'
property as 'Send NULL'. By default it is 'Exclude', which means a parameter
whose value is empty will be excluded, causing a mismatch between the actual
parameter list and the parameter schema.
> -----Original Message-----
> From: manisha [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 29, 2000 6:15 AM
> To: [EMAIL PROTECTED]
> Subject: [ND] Error with the stored procedure
>
>
>
> Hi All,
>
> I am getting the following error while executing the
> stored procedure LEAP.LEAP_ABSENCE_DATES which is accessed by
> means of a data object spr_AbsenceDates.
>
> Error code: 12
> Error message [INVALIDPOSITION] Invalid position within
> RWDBStoredProc LEAP.LEAP_ABSENCE_DATES
> Vendor error 1: 0
> Vendor error 2: 0
> Vendor message 1:
> Vendor message 2:
> projLeap.spr_AbsenceDates:c:954336493266:w:954336494016:trigge
> rDatabaseErrorEvent: execution of the DataObject
> 'spr_AbsenceDates' has failed:
> System error code is 12 ([INVALIDPOSITION] Invalid position
> within RWDBStoredProc LEAP.LEAP_ABSENCE_DATES)
> Vendor error#1 code is 0 ()
> Vendor error#2 code is 0 ()
> After getting this error in NetDynamics I run the procedure
> in ORACLE. Right after that the code seems to work fine.
> Y is it so ??
>
> Any help will be appreciated.
> Cheers
> Manisha
>
>
> ______________________________________________________________
> ___________
> To unsubscribe from this mailing list please send an email to:
> [EMAIL PROTECTED]
> Please remember to use the same email address you subscribed with.
>
> 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]
_________________________________________________________________________
To unsubscribe from this mailing list please send an email to:
[EMAIL PROTECTED]
Please remember to use the same email address you subscribed with.
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]
