Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can you copy long values beetween tables inside a Trigger?
Only if they fit all inside a varchar2, maximum size 32K, I believe.
So, define a varchar2(32000), fetch into and insert from it.
-- ------------ Kind reGards \ / | X | / \ x Gerard Robert Augustyn <augustyn_at_unn.unisys.com> schreef in artikel <666vsk$rku$1_at_mail.pl.unisys.com>...Received on Fri Dec 05 1997 - 00:00:00 CST
> Hi,
> I use Oracle ver 7.3.2 and inside a trigger I cannot declare a long data
> type variable
> but I need to move long data type from one table to another any idea how
to
> do it?
> Thanks in advance.
> Robert
>
>
>