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

Reply via email to