Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: update view..

Re: update view..

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 08 Aug 2005 21:45:20 -0700
Message-ID: <1123551912.240037@yasure>


sankar.jasti_at_gmail.com wrote:
> Hi,
> i struck with a prob in forms development.. please help me to
> solve...
>
> i have a form which is based on a view.
>
> the view which is based on a table, has functions like sum, addition
> and group by..
>
> when i tried to update table through form it says that it is not able
> to lock the record for update or delete.
>
> Thanks,
> Jasti.

With complex views the only way to perform an update through the view is to use an INSTEAD-OF trigger. Examples at www.psoug.org ... click on Morgan's Library ... click on INSTEAD-OF trigger.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Aug 08 2005 - 23:45:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US