RE: Trigger referencing LONG in 8i

There are always work-arounds :-)

• Create the insert-trigger on the table X and store the Primary-key in a replica table Y
• Then create a job which i scheduled each x minutes.
• For each row in the replica table Y, use the primary key to find the row in table X and then select the LONG column from table X and do what ever you need.

Cheers
Karsten

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nicolai Tufar Sent: Tuesday, February 08, 2005 5:56 PM To: Sunil Bhola
Cc: emelay_at_gmail.com; oracle-l_at_freelists.org; howard.latham_at_rsmb.co.uk Subject: 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

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