I have a query that is pulling a LONG field from an Oracle DB. I received the following error: illegal use of LONG datatype .....

I found information on LongReadLen in the cheetah book, but I'm still a bit confused as to the syntax or exactly how to implement the attribute. After searching Google, I found the following examples but none of them are working:

my $dbh = DBI->connect($data_source,"foo","bar",{LongReadLen => 4000})

$dbh->LongReadLen(4000);

$dbh->{LongReadLen} = 4000;

The first two don't change the error message at all. The third gives me the following message: Can't locate object method "LongReadLen" via package "DBI:db" (perhaps you forgot to load "DBI::db"?)

Just in case it's needed....
Oracle 8.1.7
Perl 5.6.1
DBI 1.28
DBD::Oracle 1.6

Any suggestions?

-Mike

Reply via email to