Upon further research, it appears that it's actually an Oracle conflict between the long field and "distinct" in my query and is not a DBI problem. Thanks anyway.

-Mike

At 05:47 PM 11/15/02 -0700, Sterin, Ilya wrote:
You'll need to post more code.  Although you do have to use LongReadLen in
this situation, this
is not why you are getting errors.

Post more code:-)

Ilya

-----Original Message-----
From: Michael Ragsdale
To: [EMAIL PROTECTED]
Sent: 11/15/02 2:32 PM
Subject: LongReadLen use

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