Search code examples
oracleformsoracle-apps

Oracle forms 10g - Private packages

While reading Oracle Applications Developer’s Guide, I came across these lines-

If a client–side (Oracle Forms) package exceeds the 10K limit, you can reduce the size of the package by putting private variables and procedures in one or more ”private packages.”

could someone explain how to create private packages?
Any helpful links is also appreciated.

Solution

  • There is no private packages as such in oracle,but you can have use private procedures or functions inside a package which are accessible only to the package.

    Procedures and Functions inside a package can be made private by not declaring them in the package specifications

    Another point to note is that private procedures or functions can be called only inside the package body and we should declare them before they are called

    In your case to solve 10k Limit issue you can define a wrapper package and them call a package where you can define a public procedure which you define in the package specifications and body and pass all the arguments and use the public procedure to only call the private procedure

    you can refer the answer in the below for example

    Execute private procedure globally in oracle package

    Wrapper package

     CREATE OR REPLACE PACKAGE BODY testPackage_Wrapper AS
 PROCEDURE publicProc IS
 BEGIN
 testPackage.publicProc();
 END;