Re: Developer 6.0 and INSTEAD-OF triggers

Hi Michael,

You have to define an on-lock-trigger on the data block that locks the correct records or even does nothing (NULL statement).

Gernot

michael_bialik_at_my-deja.com wrote:

> Hi.
>
> I am using Oracle 8.1.5 and Developer 6.
> After defining a non key preserving view, I created an
> INSTEAD_OF_UPDATE trigger for that view.
> When I am using SQL-Plus or PL/SQL - everithing works fine,
> but when I'm trying to update that view via Developer form,
> I'm getting an error message FRMxxxx saying that the view
> is NOT updatable.
> My guess is that Developer 6.0 does not "know" yet about that
> feature ( INSTEAD OF triggers ) of server and makes it's own checks.
> Oracle support people couldn't give me any definitive answer.
> Any ideas, folks?
>
> Michael.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 29 1999 - 02:47:15 CDT