Re: Inserting, Updating a View in Forms 5.0

In article <6vlegj$g03$1_at_news0-alterdial.uu.net>,   "Wayne McKinney" <wmckinney_at_tiainfo.com> wrote:
> 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

The fact that you can't find anything about this in Forms 5.0 help probably means that this property got there by mistake (?). But have you tried to talk to someone in Oracle about that? Igal.

> 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!
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Oct 09 1998 - 23:49:06 CEST