I don't know where the LENGTHB suggestion came from, but I'll fix it. Thanks.
Tim. On Wed, Dec 14, 2005 at 01:10:50PM +0100, Peter J. Holzer wrote: > On 2005-12-14 11:38:56 +1100, Ron Savage wrote: > > 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 > > The SQL reference manual says: > > char can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, > or NCLOB. > > Seems that LONG and BLOB are not allowed. > > I always used > > select dbms_lob.getlength(lob_column) as length from table ... > > to get the size of a LOB. > > hp > > > -- > _ | Peter J. Holzer | If I wanted to be "academically correct", > |_|_) | Sysadmin WSR | I'd be programming in Java. > | | | [EMAIL PROTECTED] | I don't, and I'm not. > __/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
