End User Code Objects »
Object Types »
Object Origins and Maintenance »
Calling Sequences »
Object Source File Content »
Loading Process »
Object Code Location »
Object Customization Process »
Oracle Package Header »
Sybase Procedure Header »
End User Code Options in LeasePak Server Scripts »
End User Code Objects
Loading Process
The loading process of SQL code objects occurs under 4 circumstances:
- LeasePak logical database creation – The first circumstance is on initial creation of a LeasePak database (LLDB). The LeasePak server script db_create invokes the script db_load_code during the database creation process. db_load_code implements the load order rules described in Calling Sequences. db_load_code also creates the script for granting privileges to the user code objects, which is later executed by db_set_security (also invoked by db_create).
- LeasePak logical database upgrade – The second circumstance is on upgrade of a LeasePak database to a new LeasePak release. During the upgrade process, the database conversion driver, sgenlpux_conversion, invokes the script db_drop_code, which enumerates and drops all code objects within the logical LeasePak database being upgraded. Subsequently, the conversion driver invokes db_load_code as described under LeasePak logical database creation (above).
- Maintenance build installation – The third circumstance is on installation of a maintenance build of LeasePak of the same release. Maintenance builds may require replacement of certain code objects, as well as other modifications, in order for the LeasePak database to remain compatible with the newly delivered server or client components.
- Customized code object development – The fourth circumstance is during the user's development cycle for customizing LeasePak SQL code objects. When the end user is ready to test an iteration of his development, the user and custom code objects may be replaced in a given database environment by invoking db_load_code and db_set_security with special options that restrict their functionality to the end user's code.
LeasePak Utilities |
End of Period Suite II |
End of Period Suite III |
mPower End of Period Suite |
End User Code Objects |
LeasePak Users and Roles |
End User Code Objects
© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.