Thanks to all who responded to my previous posting in which I stated my insert seem to be stuck - it was a newbie error: did not specify the ';' to terminate the SQL.
For the past hour I have been working on the next problem. I can not get past this error. Anyone has a suggestion? INSERT INTO DOCUMENT (DOCID,CREATEDTS,LASTUPDATEDTS,DISPLAYDATE,RESEARCHREPLYTO,DOCUMENTTYPE,CATI D) VALUES ('28501-rkb-lix',SYSDATE,SYSDATE,SYSDATE,'harrydATbofa.com','T',500); DBD::Oracle::st execute failed: ORA-00911: invalid character (DBD ERROR: OCIStmtExecute) at mk_docs.pl line 885. DBD::Oracle::st execute failed: ORA-00911: invalid character (DBD ERROR: OCIStmtExecute) at mk_docs.pl line 885. thanks, ----------------- Harry Duin (pronounced as hari [as in Hari Krishna] dine [as in eat out]) [EMAIL PROTECTED] tel:(312) 974-6379 pgr:(630) 362-9981 GMI IL1-231-18-32 Bank of America 231 S. LaSalle Street Chicago IL 60604