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

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

Anayway thanks for this solution.

Marc Fleischeuers wrote:

> Kees Hakvoort <c.m.j.hakvoort_at_fd.agro.nl> writes:
>
> > 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
> fetch the contents of a LONG field in (at most) 32k chunks. This is
> only for retrieval; it is not possible to insert more than 32k in a
> single LONG field with PL/SQL in Oracle 7, but there are ways in
> Oracle 8.
>
> Marc
> --
> "Het hoeft nietsch te zijn, alsch het maer wat lijckt"
> Dutch proverb, late 20th century
Received on Wed Jul 15 1998 - 23:02:02 CEST