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

Home -> Community -> Usenet -> c.d.o.misc -> Re: trigger question

Re: trigger question

From: Al Ruiz <arruiz_at_flash.net>
Date: Sun, 13 Jun 1999 01:22:18 GMT
Message-ID: <eJD83.516$sz6.1041@news.flash.net>

Al Ruiz wrote in message ...
>There is no update cascade implemented in Oracle by default. However, the
>attached package developed by the Government solves the problem with some
>constraints.
>- The owner of the parent table must be the owner of the child tables.
>- The owner of the tables must run the package in its own schema
>- The owner of the parent table must be granted create procedure and create
>trigger.
>- Once the package has been exceuted, it can be droped once the cascade
>support has been generated
>
>Have fun
>
>Al Ruiz
>
>
>
>
>
>>>
>>>
>>
>>
>
>
Received on Sat Jun 12 1999 - 20:22:18 CDT

Original text of this message

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