Re: ORACLEs LONG, RAW DataTypes in PL/SQL

From: Michael W. Steidl <mwsteidl_at_eunet.at>
Date: Sat, 16 Oct 1999 18:00:35 +0200
Message-ID: <3808A123.1649DE24@eunet.at>

Knut:

I've been in the same problem, searched a solution but found none. There are some workarounds with writing the data to a file and doing the transfer with 32k chunks - but this is a litte bit to tricky for a real word application - my opinion. The problem is the max. size of 32k for PL/SQL long variables, a legacy of (good?) old 16 bit times.

Greetings
Michael

"K. Lambert" schrieb:

> Hello,
>
> i am using Oracle 7.3.4.0 and have to work with LONG datatype in PL/SQL.
> (e.g.: building a trigger to store oldValue and newValue.) I wish to
> comparing and copying
> long or RAW Fileds.
>
> My problem is, that the data in the databasefileds are longer than 32 k.
>
> I am looking for a tip to solve this Problem or did any one know some
> package or tool??
>
> with regards
>
> Knut Lambert
> (lambert_at_consilium.de)
Received on Sat Oct 16 1999 - 11:00:35 CDT