RE: Errors while inserting into long data type

2005-04-12 Thread Andy Hassall
> 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: OCI

Re: Errors while inserting into long data type

2005-04-11 Thread Ovid
Hi Mallik, I suspect you'll get more help on a DBI list, but right off the bat, I'm wondering why it says "string literal too long". Are you adding the data directly to an SQL query? In other words, are you doing something like this? INSERT INTO TABLE (name) VALUES ('$some_var'); Not only is

Re: Errors while inserting into long data type

2005-04-11 Thread Ovid
Oh, and I see you *did* send this to the DBI list. Never mind my previous comment :) Cheers, Ovid --- Mallik <[EMAIL PROTECTED]> wrote: > Hi Friends, -- If this message is a response to a question on a mailing list, please send follow up questions to the list. Web Programming with Perl -- htt

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