Developer 6.0 and INSTEAD-OF triggers

From: <michael_bialik_at_my-deja.com>
Date: Tue, 28 Sep 1999 22:15:28 GMT
Message-ID: <7srelo$smf$1@nnrp1.deja.com>

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 Tue Sep 28 1999 - 17:15:28 CDT