I would suggest:
sp.setValue("inFNAME",getDisplayFieldValue("tbFirstName"));
sp.setValue("inLNAME",getDisplayFieldValue("tbLastName"));
Break this into multiple steps, put some CSpLog to see if you are
getting and setting the right values at this point.
Also if you look at the Netdyn log, you should be able to see the
actual Sql string that goes to the database (if you put debug leve 'Terse'
for RDBMS service).
Aby
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, May 07, 1999 12:32 PM
> To: [EMAIL PROTECTED]
> Subject: [ND] Stored Procedure: am I missing something? Please help
>
> 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]
_________________________________________________________________________
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]
