Re: retrieve long raw value and insert into another table, HELP

From: bjin <jinbo_at_hpsgns1.sgp.hp.com>
Date: Thu, 03 Jun 1999 08:56:17 +0700
Message-ID: <3755E0C1.DF032964@hpsgns1.sgp.hp.com>

Hi Max,

For Oracle7.3, pl/sql data type "long raw" has a limitation of 32k.

If your data in long raw field is less than 32k, you can select it into a long raw variable and then insert the variable into another table.

If your data is larger than 32k, the only way I know is to use pro*c or oci.

Hth
bjin

Max wrote:

> Hi,
> my problem is the following:
> I have a table with a long raw field.
> I have to read records from this table
> and insert them into another table.
> How I can do that in pl/sql ???
> The Oracle version running is 7.3
> The operative system is Unix Solaris.
> Any help will be appreciated.
> bye
> Max from Rome.
Received on Wed Jun 02 1999 - 20:56:17 CDT