Read the docs; look for LongReadLen. ----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Shah, Urmil [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 14, 2004 10:23 AM 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 This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
