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

Home -> Community -> Usenet -> c.d.o.server -> Re: Insert LONG type to another table by trigger: Internal error

Re: Insert LONG type to another table by trigger: Internal error

From: Jeff Y. Y. <yuanjeff_at_yahoo.com>
Date: 13 Mar 2002 19:26:45 -0800
Message-ID: <a2bc9497.0203131926.f77e4c1@posting.google.com>


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

Original text of this message

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