Hi,
No success with stored procedure yet.
###############################################################
my previous mail
I have a stored procedure which inserts some values in the table and returns back a
single value.
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' as well as
'custom'.
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.)
doUser: is the stored procedure I created in netdynamics
#############################################################
****************************************************************
The log gives me the following error
Vendor message 1: S1000
Vendor message 2:[Oracle][ODBC][Ora]ORA-06550: line1, column 14:
PLS-00201: identifier 'PROC_NAME' must be declared
Here PROC_NAME is the name of the stored procedure in Oracle.
****************************************************************
My ODBC connection is fine.
Why is netdynamics not able to recognize the stored procedure in oracle.
Please help
Thanks,
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]
