DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2000


    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


  2. #2
    Join Date
    Dec 2000
    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!!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.