[ND] executeimmediate not inserting?

[Neeraj]

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]