Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to update through a joined view in 8i?
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 Sun Sep 10 2000 - 09:33:18 CDT