Re: How can I translate a LONG RAW field INTO a VARCHAR2 one?
Date: 2000/07/17
Message-ID: <8kve97$pe$1_at_nnrp1.deja.com>#1/1
Hello Ema,
You will need to use the DBMS_SQL package to transfer the text in 256 byte chunks into a PL/SQL table. From there you can insert it into a table. You will need to use the DEFINE_COLUMN_LONG and COLUMN_VALUE_LONG procedures.
The O'Reilly Book Oracle built-in packages by Steven Feuerstein (ISBN 1- 56592-375-8) also has an example of how to do this on page 79.
Hope this is of some help,
David
In article <8kn84s$k25$1_at_fe1.cs.interbusiness.it>,
"Ema" <carrai_at_eng.it> wrote:
> Hello world!!
>
> ...and sorry for my English.
>
> I need to update a VARCHAR2(4000) field with a LONG ROW one
containing only
> text.
>
> My database is ORACLE 8.05 and I would like to create a PL/SQL
script to
> perform this operation. Someone can help me?
>
> Thank you very much...
>
> Emanuele
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Jul 17 2000 - 00:00:00 CEST