System-defined Stored Packages

System-defined Stored Packages#

The system-defined Stored packages are the fundamental packages provided by Altibase, and they are owned by the SYS user.

Altibase provides the system-defined Stored packages as follows.

Packages	Description
DBMS_APPLICATION_INFO	Configures the performance view in order to manage information of client application.
DBMS_ALERT	Notifies other users of events that occur in the database.
DBMS_CONCURRENT_EXEC	Allows procedures to be concurrently executed.
DBMS_LOCK	Offers an interface in which the user can request lock or unlock.
DBMS_METADATA	Provides the ability to extract object creation DDL statements or privileged GRANT statements from the database dictionary.
DBMS_OUPUT	allows the user to print a character string stored in buffer to a client.
DBMS_RANDOM	Creates arbitrary numbers.
DBMS_RECYCLEBIN	Can completely purge the tables which has been dropped and managed in the recycle bin.
DBMS_SQL	Provides procedures and functions utilizing dynamic SQL.
DBMS_SQL_PLAN_CACHE	Provides two stored procedures which keeps or removes the specified execution plan in SQL Plan Cache.
DBMS_STANDARD	Provides various default sub programs
DBMS_STATS	Package views and modifies the stats information
DBMS_UTILITY	Provides various utility subprograms.
STANDARD	In addition to the basic data types, it defines the types that can be used without declaration in PSM.
SYS_SPATIAL	Provides subprograms related to GEOMETRY.
UTL_COPYSWAP	Online DDL is supported by COPY & SWAP method
UTL_FILE	Can read and write text files managed by an operating system.
UTL_RAW	Can modify or alter RAW(VARBYTE) type data into a different type.
UTL_SMTP	Executes SMTP to send E-mail on SMTP server.
UTL_TCP	Controls TCP access in a stored procedure.