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 -> Trigger on nested table column

Trigger on nested table column

From: Daniil Bodrov <danilb_at_sphaera.ru>
Date: Sat, 30 Nov 2002 12:25:12 +0300
Message-ID: <asa05p$12k7$1@gavrilo.mtu.ru>


Hello,

Is any way to fire trigger when user use unnesting queries like this:

INSERT INTO TABLE(SELECT nested_table FROM parent_table WHERE id = 1) VALUES ....
UPDATE TABLE(SELECT nested_table FROM parent_table WHERE id = 1) SET... DELETE FROM TABLE(SELECT nested_table FROM parent_table WHERE id = 1);

or restrict such operations.
I find that triggers on parent_table don't work in that case.

I can't believe that isn't any way to control user actions on this kind of columns.

Thanks,
Danil Received on Sat Nov 30 2002 - 03:25:12 CST

Original text of this message

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