Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Perl-DBI Question
I tried to query a LONG column from a table using DBI module
in Perl. I set both LongTruncOk (1) and LongReadLen (65535),
and as a result, the data was truncated. I had to set the LongTruncOk,
otherwise it errored out when I ran the perl script.
Is there anyway, like "SET LONG 2000000000", so that the query returned all the data from that long field?
TIA.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
![]() |
![]() |