Patent ID: 7899797

Claim:
A method for providing package resolution in a database system, the method comprising: providing a SET CURRENT PACKAGE PATH statement within a server of the database system, wherein the SET CURRENT PACKAGE PATH statement identifies a selected list of a plurality of qualified package collections during runtime, wherein each identified package collection includes a plurality of packages and each package is usable during execution of one or more other database statements issued by the application; responsive to issuance of a database statement by the application, executing the database statement to search the qualified package collections in the search precedence order and locate at least one of the plurality of packages included in at least one of the identified package collections, the located at least one package for use with the database statement; and caching the at least one package in a storage of the server, the at least one package being used during execution of the one or more other database statements issued by the application, and in response to not finding a particular package in an associated one of the package collections during the search of the package collections, creating a not-found entry in a user database for the not-found package, such that subsequent searches for the not-found package find the not-found entry and skip a loading process for the associated package collection.