Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: problem with updatable view an forms
Juergen Koehler wrote:
> Hi, everybody,
>
> can anyone help me with the following problem?
>
> I created an updatable view of 5 tables a,b,c,d,e. Therefor I had to join a
> with b, b with c and d, c with d and e. The system view
> "USER_UPDATABLE_COLUMNS" says that nearly every column is updatable (but not
> insertable or deletable).
> If I do an update on this view via sqlplus it works. When I use a forms
> module with a block on this view the following message appears: "it is not
> possible to update the view". I set the block property "update changed
> columns only" to yes.
> Does anybody knows what the problem is?
>
> Greetings
>
> Jürgen Köhler
Yes. Create an INSTEAD OF trigger on the view.
Daniel Morgan Received on Thu Jan 30 2003 - 10:28:05 CST