Thank you all for the correct pointer. It works great.
Urmil -----Original Message----- From: Sterin, Ilya (I.) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 11:27 AM To: Shah, Urmil; [EMAIL PROTECTED] Subject: RE: How to read LONG data type Set LongTruncOK and LongReadLen, also make sure you are always binding anything that has to do with Longs. See docs for above parameters. Ilya -----Original Message----- From: Shah, Urmil [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 12:23 PM To: [EMAIL PROTECTED] Subject: How to read LONG data type I have a column in a table that has a data type=LONG. The content of this column is a text file(it is not a pointer to a text file but the raw text file itself). When I try to simple select statement in perl it gives following error. Do I need to notify perl that it is a LONG data type and read it differently. DBD::Oracle::st fetchrow_array failed: ORA-01406: fetched column value was truncated (DBD: ORA-01406 error on field 3 of 3, ora_type 8, DBI attribute LongTruncOk not set and/or LongReadLen too small) at pgmsetup.pl line 22. Thanks in advance. Regards, Urmil
