Re: Size of LONG RAW object?

The reason is, you may not use any function upon a long or long raw field within sqlplus. It is not a technical restriction but a syntactical one. Look into $ORACLE_HOME/rdbms/admin/dbmssql.sql, you may find something useful for handling long objects.

Martin Haltmayer

Ellen Liang wrote:
>
> I tried your suggestion (vsize), but error in :
>
> select vsize(image)
> *
> ERROR at line 1:
> ORA-00997: illegal use of LONG datatype
>
> Can you elaborate ?
> Natarajan Malupillai <mnatty_at_ix.netcom.com> wrote in article
> <34CFF6B6.48DB_at_ix.netcom.com>...
> > Ivars Grinbergs wrote:
> > >
> > > Hi all,
> > >
> > > Is there any way to determine size of LONG RAW object stored in Oracle
> > > 7.3.3 server, e.g., is there something like LENGTH(long raw)?
> > >
> > > Sincerly,
> > > I.Grinbergs
> > >
> > > P.S. Please, e-mail a copy of replay directly to my e-mail address!
> > Try vsize(long raw), it should give you the size in bytes
> >
> > Natty
> >
Received on Wed Feb 04 1998 - 00:00:00 CST