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

From: Marc Fleischeuers <Marc.Fleischeuers_at_kub.no-spam.nl>
Date: 14 Jul 1998 09:21:38 +0200
Message-ID: <u3ec43njx.fsf_at_kub.nl>


[Quoted] 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:

[Quoted] 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 Tue Jul 14 1998 - 09:21:38 CEST

Original text of this message