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

In article <a2bc9497.0203131926.f77e4c1_at_posting.google.com>, yuanjeff_at_yahoo.com says...
>
>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.
>

cannot access :new and :old for longs in a trigger.

anything over 32k will fail with plsql.

you should be using a CLOB.

>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

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp