Found this Web page on the topic; HTH:

http://www.arikaplan.com/oracle/ari80597b.html

Ted Behling

-----Original Message-----
From: Ron Savage [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, December 13, 2005 7:39 PM
To: List - DBI users
Subject: LongReadLen, lengthb() and Oracle

Hi Folks

The DBI docs for LongReadLen say to use LENGTHB() for Oracle, but that
gives me an error:

ORA-00932: inconsistent datatypes: expected NUMBER got LONG

when I do:

select max(lengthb(a_session) ) from sessions;

And, yes, sessions is for CGI::Session, and a_session is of type long.

This is Oracle 10, DBI 1.48, DBD::Oracle 1.16.

Any ideas?
--
Ron Savage
[EMAIL PROTECTED]
http://savage.net.au/index.html



Reply via email to