Try to execute the sql (ND sent to oracle)directly from sql+ or worksheet manager and
see if it works.
You can get the sql string from the rdbms log if you turn debug logging on.
"Neeraj" <[EMAIL PROTECTED]> wrote:
>>Let me tell you what I am trying to do here, I am inserting 11 columns in a table
which is in Oracle 7.3.3 and using the code below. It executes but is not
doing the
required insertion process. I fail to understand why is it not inserting the
record
with the values i am passing.>>>May be u can help me if I am missing
something. Or
help me trap the error.>>try> {>
CSpDataObject.executeImmediate (>
"oracle",>
"INSERT
INTO PERSONNEL " +> " (
SSN, RATE, LASTNAME, FIRST, MIDDLE, WC_ID, PRD, EAOS,
REPORT, BFIMA_NEC, UIC ) VALUES " +>
"( '" + SSN + "', '" + Rate + "', '" +
LastName + "', '" + FirstName + "', '" + MiddleName + >
"','" + WCID + "','"
+ PRD + "','" + EAOS + "','" + Report + "','" + BFIMA + "', '" + UserID +
"')");> >
CSpDataObject.executeImmediate
("oracle","COMMIT USING SQLCA");> >
CSpPage updatedPage =
CSpider.getPage("pgManagePersonnelMenu");>
CSpHttp.reset();>
updatedPage.load(true);> command
= STOP_PROCESSING;> >
> }>
catch (Exception ex)> {>
>
CSpPage updateerrorPage =
CSpider.getPage("pgSQLError");>
CSpHttp.reset();>
updateerrorPage.load(true);> command
= STOP_PROCESSING;> >
}>>>thanks>Neeraj
_________________________________________________________________________
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]
