Re: Length of a long raw field stored in the database > 32K in PL/SQL

c.m.j.hakvoort_at_fd.no-spam.agro.nl writes:

> I've tried this solution but it only seems to work for long columns and not for
> long raw columns.

I'm sorry, I missed that in your original post. You are right, there's only one pl/sql package that I know to manage raw data, that is utl_raw (you might need to install it). This package is of little use for you though, as it does not retrieve raw data from the database.

> > > Can someone help me,
> > >
> > > In PL/SQL i want to retrieve the length of a long raw field stored in
> > > the database where the size is > 32K. Because a long raw variable in
> > > PL/SQL can have the max size of 32K the following works fine if the size
> > > stored in the database is <= 32K:
> >
> > Take a look at the dbms_sql package, in particular the
> > define_column_long/column_value_long combo. They will enable you to
Received on Thu Jul 16 1998 - 09:06:39 CEST