Inserting, Updating a View in Forms 5.0

From: Wayne McKinney <wmckinney_at_tiainfo.com>
Date: Fri, 9 Oct 1998 11:46:12 -0500
Message-ID: <6vlegj$g03$1_at_news0-alterdial.uu.net>

[Quoted] Has anyone gotten Forms 5.0 to successfully insert into and update (and maybe even delete) a block that's based on a view? I can see that Oracle probably intended the INSERT PROCEDURE and UPDATE PROCEDURE options on the Property Sheet for the view's block as the vehicles for performing the Inserts and Updates.

The Forms on-line help doesn't help. I can't find any references on how to do this on Oracle support nor on Dejanews (of course, I could be asking the wrong question). The included Forms 5.0 demo of a block based on a Stored Procedure performs updates into a table and not back into the Stored Procedure.

A workaround was suggested recently by Thomas Kyte when someone asked how to [Quoted] update a view in general. He said to use the 'instead of' triggers to perform the updates and inserts into the view. That's fine. I can do that, but Oracle clearly meant something else when they put the INSERT PROCEDURE and UPDATE PROCEDURE options on the view's block property sheet.

Any help would be appreciated! Received on Fri Oct 09 1998 - 18:46:12 CEST