9 Built-In Utility Packages

Table of Contents Previous Next


9 Built-In Utility Packages

This chapter describes the built-in packages that are provided with Advanced Server. For certain packages, non-superusers must be explicitly granted the EXECUTE privilege on the package before using any of the package’s functions or procedures. For most of the built-in packages, EXECUTE privilege has been granted to PUBLIC by default. See the GRANT command for granting privileges.
All built-in packages are owned by the special sys user which must be specified when granting or revoking privileges on built-in packages:
Note: When executing a built-in package procedure that has no IN OUT or OUT parameters from within a PL/pgSQL function or trigger, the PERFORM statement must be used as illustrated by the following example:
When executing a built-in package procedure that has a single IN OUT or OUT parameter from within a PL/pgSQL function or trigger, a variable with a data type compatible with the IN OUT or OUT parameter must be assigned the result of the evaluated function as illustrated by the following example:
When executing a built-in package procedure that has more than one IN OUT or OUT parameters from within a PL/pgSQL function or trigger, a variable of type RECORD must be assigned the result of the evaluated function. The returned values of the individual IN OUT and OUT parameters can then be referenced from the individual fields of the record in the form, record_name.parameter_name where record_name is the RECORD type variable name and parameter_name is the name of an IN OUT or OUT parameter declared in the built-in package procedure parameter declaration as illustrated by the following example:
See Section 9.1.5 for the parameter declarations of the DBMS_ALERT.WAITANY procedure.

9 Built-In Utility Packages

Table of Contents Previous Next