Answered Questions

  • What are the disadvantages of Packages and triggers??

    shriram

    • Jan 5th, 2018

    To add one more point to the disadvantages of packages :
    We cannot declare ref cursor in a package.
    also if a dependent object is dropped the entire package body is invalid until it is recompiled.

    Kavitha

    • Nov 19th, 2007

    Disadvantages of Triggers    It is easy to view table relationships , constraints, indexes, stored procedure in database but triggers are difficult to view.    Triggers execu...