Re: length of a long raw column

Thanks Sybrand, but it does not work.

SQL> select vsize(foo) from foobar;
select vsize(foo) from foobar

             *
ERROR at line 1:
ORA-00997: illegal use of LONG datatype

It's possible to fetch a LONG RAW piecewise?

Thanks
Thomas

Sybrand Bakker wrote:
>
> Use the vsize function.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Thomas Kober <t.kober_at_bigfoot.de> schreef in berichtnieuws
> 392A4A4C.F89BFAFF_at_bigfoot.de...
> > Hi Oracle PL/SQL experts,
> >
> > how do i examine the length of a long raw column
> > with PL/SQL and sqlplus?
> >
> > Example:
> > create table foobar (id number, foo long raw);
> > insert into foobar values (1, '010101');
> >
> > select length(foo) from foobar
> > *
> > ERROR at line 1:
> > ORA-00932: inconsistent datatypes
> >
> > Can Oracle PL/SQL experts there help me?
> >
> > Thanks
> > Thomas
Received on Mon May 29 2000 - 00:00:00 CDT