PACKAGE:They are units, which consists of many executable codes that are meant for SQL statements for one respective DBRM (Database request module).
Below are some advantages of Packages:
<> It ensures that you do not have to bring a large collection of DBRM members together for a particular plan.
<> In case of making changes in a program that will eventually lead to errors, then the decrease in fallback complexities can be made with the help of Package.
<> It is advisable to go for a small collection instead of a large one. Abstain from the cost of large collection of a bind.
<> In the course of automatic binding or rebinding of a specific plan, ensure that the total transactions attached to the process are unavailable.
Posted Date:- 2021-09-03 01:39:40