Hi Philip, Thanks for your reply. It worked with bind_param.
I have one more question, how to set the LongReadLen parameter in a perl script? Thanks, Mallik. -----Original Message----- From: Philip Mikal [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 11:36 PM To: 'Mallik'; [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 for general perl programming questions. Regards, Philip Mikal ITD Webteam Cisco Internet Experts -----Original Message----- From: Mallik [mailto:[EMAIL PROTECTED] Sent: Monday, April 11, 2005 4:10 AM To: [EMAIL PROTECTED] Subject: Errors while inserting into long data type 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: OCIStmtExecute) at MT/TACDbManager.pm line 445. Whereas we can insert upto 2GB of data in long data type. Pl. help me out to solve this. Thanks & Regards, Mallik. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>