Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: problem with updatable view an forms
Hi, Daniel,
I already tried to work with an instead of trigger . But I get the same error message in the forms module ("it is not possible to update the view").
Juergen Koehler
"DA Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3E395295.C0164040_at_exesolutions.com...
> 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 Fri Jan 31 2003 - 02:33:11 CST