Why do we need Package?

If I create N number of small procedures with one PL/SQL block (or) procedure why we need package?

Showing Answers 1 - 1 of 1 Answers


  • Mar 19th, 2017

In package, we can have private procedure/function/record type variables which can hide the computation logic and original executable statements. But in a procedure, we cant create such private procedure/function/record type variables. Also, we keep similar procedure/functions in one place, so that that will help to easy navigation, maintenance and debug.
Hence, creating N number of procedure will create lot of issues during navigation, maintenance and debug.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions