Re: How can I translate a LONG RAW field INTO a VARCHAR2 one?

In article <8knaoe$g1i$1_at_nnrp1.deja.com>,   oratune_at_aol.com wrote:
> In article <8kn4nc$32r$1_at_fe2.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
> >
> >
>
> This should give you some idea:
>
> declare
> coltxt varchar2(4000); -- place long text here
> keyval srctbl.key%type; -- common key between tables
> ctr number:= 0;
> cursor get_txt is
> select key, txtcol -- get the long column and the key
> from srctbl; -- from the source table
> begin
> open get_txt;
> loop
> fetch get_txt into keycol, coltxt;
> exit when get_txt%notfound;
> update desttbl -- table to update
> set txt = coltxt -- column to update
> where keycol = keyval; -- common key column in destination
 tbl
> ctr := ctr + 1;
> if ctr = 100 then
> commit;
> ctr := 0;
> end if;
> end loop;
> commit;
> close get_txt;
> end;
> /
>
> By selecting the long data into a text column it allows the
 destination
> table to be successfully updated.
>
> I hope this helps.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

After re-reading the initial post I am confused -- are you attempting to insert LONG RAW data into a VARCHAR2(4000) column? If that is the case you won't be able to do as you wish, as far as I know. I have tried and cannot find a method by which this will work since LONG RAW data is binary and the hextoraw() and rawtohex() functions won't operate on a LONG RAW column. For LONG data the above PL/SQL will work, but not for LONG RAW.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.