hari_mech

 Profile Answers by hari_mech 

• Aug 20th, 2007

 

Disadvantages of Packages:
1. You cannot reference remote packaged variables directly or indirectly..
2. Inside package you cannot reference host variable..
3.
We are not able to grant a procedure in package..

Disadvantages of Trigger:
1. Writing more number of codes..

Kavitha

• Nov 18th, 2007

 

Disadvantages of Triggers
   It is easy to view table relationships , constraints, indexes,
stored procedure in database but triggers are difficult to view.
   Triggers execute invisible to client-application. They are
not visible or can be traced in debugging code.
   It is hard to follow their logic as it they can be fired
before or after the database insert/update happens.
   It is easy to forget about triggers and if there is no
documentation it will be difficult to figure out for new developers for their
existence.
   Triggers run every time when the database fields are updated
and it is overhead on system. It makes system run slower.

Disadvantage of packages:
   Unnecessary module loading.
   Unable to load large packages into memory.
   Unable to compile large packages.
   Lack of synonym support.
   No version control.

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.