TRIGGER WHILE DROPPING A TABLE in Oracle 10G R2
Is there any way, in Oracle 10G R2 PL/SQL, to create a TRIGGER that fires when DROPping a particular table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
How can I fix this?
ASKER
You're right shru_0409, I've substituted the SCHEMA keyword with the table name... (my error).
ASKER
I would like to write a trigger that, before dropping a particular table ALPHA, drops all the remaining tables.
ASKER
Any other clues?!
That trigger will be:
1) Dangerous
2) Hard to write, since it will be recursively calling itself by dropping another table (which will trigger again).
Why not just use PL/SQL or SQL to generate the drop statements on the fly?
1) Dangerous
2) Hard to write, since it will be recursively calling itself by dropping another table (which will trigger again).
Why not just use PL/SQL or SQL to generate the drop statements on the fly?
ASKER
Don't worry about hazard of that trigger, help me to write it.
ASKER
UP
>>Don't worry about hazard of that trigger, help me to write it.
Good luck.
Good luck.
ASKER
Thanks! ;-)
ASKER