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
pgpQaB5uj76as.pgp
Description: PGP signature
