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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to update through a joined view in 8i?

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

From: Ghost <thomp901_at_micron.net>
Date: Sun, 10 Sep 2000 08:33:18 -0600
Message-ID: <39BB9BAE.6174D973@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 Sun Sep 10 2000 - 09:33:18 CDT

Original text of this message

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