Re: Transferring LONG RAW from TAB1 to TAB2

Hi.

 There is a reference HOWTO copy LONG datatypes at  Thomas Kyte personal page http://govt.us.oracle.com/~tkyte/  but he says there that for LONG RAW you must use Pro*C.

 Good luck. Michael.

In article <37E654BC.57470EF9_at_theleme.com>,   Yann Chevriaux <chevriaux_at_theleme.com> wrote:
> Many thanks: it works ... until 32K !
>
> I've just learned that in PL/SQL, long variables can't execed 32K !
> As the documents users want to store are often over 50K large, I must
find
> another solution.
>
> Yann.
>
> michael_bialik_at_my-deja.com a écrit :
>
> > In article <37E10FD1.F00D0715_at_theleme.com>,
> > Yann Chevriaux <chevriaux_at_theleme.com> wrote:
> > > I would to know how to copy a LONG RAW column from a table to
another.
> > >
> > > The following based function failed with:
> > > ORA-00997: illegal use of LONG datatype
> > >
> > > function ArchiveRawData(dataId in number)
> > > return number
> > > is
> > > newArcId number;
> > > begin
> > > newArcId := NewId; -- NewId is a based function that return an
UID
> > >
> > > insert into rawArchive (id, rawdata)
> > > select newArcId, rawdata
> > > from rawCurrent
> > > where id = dataId;
> > >
> > > return newArcId;
> > >
> > > end;
> > >
> > > I thought it could be a PL/SQL limitation but even with a simple
SQL
> > > statement it fail as well.
> > >
> > > Configuration: NTServer; Oracle 7.3.2
> > >
> > > Please help !!!
> >
> > >
> > >
> >
> > Use PL/SQL instead :
> >
> > function ArchiveRawData(dataId in number)
> > return number
> > is
> > newArcId number;
> > newData rawCurrent.rawdata%TYPE;
> > begin
> > newArcId := NewId; -- NewId is a based function that return an
UID
> >
> > select rawdata into newData from rawCurrent
> > where id = dataId;
> >
> > insert into rawArchive (id, rawdata) values(newArcId,newData);
> >
> > return newArcId;
> >
> > end;
> >
> > Good luck. Michael.
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 21 1999 - 15:42:20 CDT