On Wed, 14 Dec 2005 13:10:50 +0100, Peter J. Holzer wrote:
Hi Peter
> select dbms_lob.getlength(lob_column) as length from table ...
> to get the size of a LOB.
Thanx, but that didn't work either. Perhaps getlength() has the same
restrictions as lengthb()?
This is in SQL/Plus:
SQL> select dbms_lob.getlength(a_session) as length from sessions;
select dbms_lob.getlength(a_session) as length from sessions
*
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 15/12/2005
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company
