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:
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
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:
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=enq=Inserting+and+Updating+LONG%2FLOB+Colum
ns
Also, you may find using the perl-trolls alias better for general perl