I have tables which will be created dynamically. Now i have to create dynamic triigers fo these tables. Is it possible.Is there anyone to help me in this case
Thanks in Advance
While I've never done them, I see no reason why you couldn't create them, they would be difficult o do though as you would have to be very careful about how many different scenario's there are and therefore how many different permentations of code there could be as each of these must compile (Or it will fall over when you try to dynamically create the trigger)
First off do you really need dynamically created tables. Could you use a generic table with perminent triggers and just truncate it at the start and then use isert into select to populate it.
If the above won't work for you then Look up Native SQL (if your using 8i) or DBMS_SQL (if your on Oracle 7 or Native won't do it) on technet.oracle.com. Membership is free and you can search the Oracle Manuals online.
Good luck I have a feeling you will need it!!
Click Here to Expand Forum to Full Width