Dynamic Triggers???
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Dynamic Triggers???

  1. #1
    Join Date
    Oct 2000
    Posts
    2

    Smile

    Hi
    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

    Regards
    Anandhi

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

    Mike.

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