Re: Trigger referencing LONG in 8i

Uh, oh. Too bad.

It is an ancient system with a packaged mission-critical application with no source code and no support. We have absolutely no right to change anything. We could only query the tables originally and after lengthly negotiation they allowed us to create insert triggers.

But now... I don't know what we can do now.

Thanks very much for information, now we will look for solutions elsewhere.

Best regards,
Nicolai Tufar

On Tue, 8 Feb 2005 07:11:53 -0800 (PST), Sunil Bhola <oraclebhola_at_yahoo.com> wrote:
> Hi Nicolai,
>
> If you are using 8i than I think there is no solution for that to use LONG
> in your trigger code. But yes in 9i you can change the long column to LOB,
> then you can use that column in trigger code.
>
>
>
>
> Nicolai Tufar <ntufar_at_gmail.com> wrote:
> Greetings,
>
> We have a legacy application using 8i database which we have to
> replicate using insert triggers. One of the tables includes LONG
> column, when we try to create a trigger it fails immediately with
> "ORA-04093: references to columns of type LONG are not allowed in
> triggers" error message.
>
> We can not upgrade database or change the column type. Does anyone
> have experience dealing with triggers on tables including LONG column?
> What can be done in this situation?
>
> Thanks in advance,
> Nicolai Tufar
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> ________________________________
> Do you Yahoo!?
> Yahoo! Search presents - Jib Jab's 'Second Term'
>
>

--
http://www.freelists.org/webpage/oracle-l