Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can you copy long values beetween tables inside a Trigger?

Re: How can you copy long values beetween tables inside a Trigger?

From: Gerard H. Pille <ghp_at_santens.be>
Date: 1997/12/05
Message-ID: <01bd0165$8b092940$7b1340c0@pcghp.santens.be>#1/1

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>...

> 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
>
>
>
Received on Fri Dec 05 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US