Hi,
I have a stored procedure which inserts some values in the table and returns back a
single value.
I am using the followin code.
public int btExecute_onWebEvent(CSpWebEvent event)
{
CSpProcedure sp=(CSpProcedure)CSpider.getDataObject("doUser");
sp.clearAllValues();
sp.setValue("inFNAME",getDisplayFieldValue("tbFirstName"));
sp.setValue("inLNAME",getDisplayFieldValue("tbLastName"));
sp.execute();
return(PROCEED);
}
I have set execution property of the stored procedure as 'onsubmit'.
I also tried binding the textboxes and using
return(executeAllModifyingDataObjects());
The procedure works fine in oracle but when trying to run it in
netdynamics it gives me the following error
TBS.doUser.triggerDatabaseErrorEvent: execution of the DataObject 'doUser' has failed:
TBS.doUser. System error code is 5 (SQL call failed.)
TBS.doUser. Vendor error#1 code is 0 (S1104)
TBS.doUser. Vendor error#2 code is 1 ([Oracle][ODBC]Invalid precision value.)
I do not know where is the execution of the stored procedure failing.
Please help
Thank you,
Hetal
_________________________________________________________________________
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]
