What is Public and Private Procedures in PL/SQL?

Oracle Apps Interview QuestionsCategory: PL/SQLWhat is Public and Private Procedures in PL/SQL?
Questions Master asked 10 years ago
1 Answers
Shailender Thallam Staff answered 10 years ago

Public Procedures:
Any procedures declared inside the package specification are visible outside the package and can be accessed in any objects.
 
Private Procedures:
The procedures that are declared inside the package body, you are restricted to use within that package.

Therefore, PL/SQL code outside the package cannot reference any of the procedures that were privately declared within the package.