Re: How to update through a joined view in 8i?

Chad,

I appreciate your taking the time to respond, but this misses the point of my original question. The pre-insert triggers were availiable before Oracle 8i. Starting in 8i, Oracle has claimed that you can insert, update, and delete records directly through a JOINED view - without using triggers - under certain conditions. The example they give for it, though, doesn't work. If you've seen anyone use this ability, I'd appreciate hearing how they did it.

"Ghost" <thomp901_at_micron.net> wrote in message news:39BB9BAE.6174D973_at_micron.net...
> I don't have my books here, but I think you use a pre-insert
> trigger. If you're trying to update Oracle Apps databases, you can
> tie in the appropriate APIs at that point. I've done it once just to
> try it out, but not for production use.
>
> CA wrote:
> >
> > Anyone here successfully updated (or deleted or inserted) data through a
> > joined view in Oracle 8i? The online docs provide an example of how to
 do
> > this, and the example itself doesn't work. If anyone could provide a
 brief
> > example of how to make this work, I'd sure appreciate it.
>
> --
> ---------------------------------------------------------------------
> Chad Thompson,
> Programmer Analyst: VB, VC++, PLSQL, Oracle HRMS, Security Apps
> Home: thomp901_at_micron.net
>
> Thou shalt not tick off the dragon.... for thou art crunchy and
> taste good with ketchup.
> ---------------------------------------------------------------------
Received on Mon Sep 11 2000 - 10:12:43 CDT