Developer 6.0 and INSTEAD-OF triggers

From: <michael_bialik_at_my-deja.com>
Date: Tue, 28 Sep 1999 22:14:37 GMT
Message-ID: <7srek5$skt$1_at_nnrp1.deja.com>



Hi.

[Quoted]  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 - 00:14:37 CEST

Original text of this message