RE: Errors while inserting into long data type

2005-04-11 Thread Mallik
7;; [EMAIL PROTECTED] Subject: RE: Errors while inserting into long data type Hi Mallik, String literals in Oracle are limited to 4000 characters. http://www.google.com/search?hl=en&q=Inserting+and+Updating+LONG%2FLOB+Colum ns Also, you may find using the perl-trolls alias better fo

Errors while inserting into long data type

2005-04-11 Thread Mallik
Hi Friends, I am using oracle database and I have column of long data type. I insert the data into this column thru perl script. If the inserted data exceeds 4000 chars, it is giving me the following error. DBD::Oracle::st execute failed: ORA-01704: string literal too long (DBD ERROR: OCIStmtExec