thanks.
I am compiling the stored procedure each time in ORACLE before executing the
netdynamics page which uses the stored procedure and it works fine.
Aby Mathew <[EMAIL PROTECTED]> wrote:
>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]
