Re: PL/SQL & Data warehouse ?

Jim Smith wrote:
>
> Hello Everybody,
> Before I go to the effort of creating a new PL/SQL routine, I'm checking to see if
> one already exists. I'm unable to use existing database triggers in our database
> warehouse due to security reasons, (which to me makes good sense). I'm looking
> at creating a PL/SQL routine that will check a table in the data warehouse for new
> inserts and updates and then populate those changes to one of my tables. Has
> anyone created such code? Have you seen anything else that could do this
> process effectively?
> Jim

How about putting a trigger on the source tables to record the rowid of the insert/update. No searching needed at all then Received on Wed Feb 21 1996 - 00:00:00 CET