Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert LONG type to another table by trigger: Internal error
Could you please give the detail if you know the detail? I tried ways,
but did not make it work. Again, I need a trigger.
Thanks a lot.
"santosh sharma" <santysharma_at_yahoo.com> wrote in message news:<a6op1c$g2h35$1_at_ID-84096.news.dfncis.de>...
> You can not use :new and :old with long data type columns in triggers.
> This is one of the restriction of long data types. There are other ways to
> copy long data type from one table to another :
> 1. SQL Copy
> 2. PL/SQL , it allows upto 32000 chars
> 3. JDBC program
>
> regards,
> santysharma
Received on Wed Mar 13 2002 - 21:26:45 CST