Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: trigger question
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
![]() |
![]() |