Re: Developer 6.0 and INSTEAD-OF triggers

From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 29 Sep 1999 15:47:01 GMT
Message-ID: <7stc9l$guu$1@relay1.dsccc.com>

Expand BLOCKS, click on the view name, raise the property sheet under Database, is insert FALSE?. If TRUE, Expand ITEMS and check each item.

Then check the FORM and block pre-insert triggers.

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.

--
While Alcatel may claim ownership of all my ideas (on or off the job), Alcatel does not claim any responsibility for them. Warranty expired when u opened this article and I will not be responsible for its contents or use. Received on Wed Sep 29 1999 - 10:47:01 CDT