Trigger in Package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Trigger in Package

  1. #1
    Join Date
    Oct 2000
    Posts
    1
    1. Can we use triggers in packages? If not why

    2. How we can tell to the Oracle, which index to use. Please give code if necessary



  2. #2
    Join Date
    Sep 2000
    Posts
    47
    1. Can we use triggers in packages? If not why

    Trigger is the code that is executed when a specific event, like : insert, update or delete, occurs on an object. As such you cannot call triggers from packages. To execute the trigger code in your package you can put down that code into a function or procedure and then call that code from your trigger and/or package.


    2. How we can tell to the Oracle, which index to use. Please give code if necessary

    Consider the following example :

    select /*+ INDEX(table_name index_name1 index_name2...) */ column1, column2 ...

    Hope this will help.

    Regards,

    Pinakin.

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