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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trigger referencing LONG in 8i

RE: Trigger referencing LONG in 8i

From: Karsten Weikop <oraclel_at_weikop.com>
Date: Tue, 8 Feb 2005 20:09:50 +0100
Message-ID: <003401c50e11$d20d3140$6401a8c0@KW>


There are always work-arounds :-)

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
Received on Tue Feb 08 2005 - 14:13:38 CST

Original text of this message

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