Oracle8i Supplied PL/SQL Packages Reference
Release 2 (8.1.6)

Part Number A76936-01

Library

Product

Index

Updated information for Release 8.1.7 can be found in the Oracle8i Documentation Addendum.
Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Oracle Supplied Packages

Package Overview
Using Oracle Supplied Packages
Creating New Packages
Referencing Package Contents
List of Oracle Supplied Packages
Subprograms in Supplemental Packages
Calendar
SDO_ADMIN
SDO_GEOM
SDO_MIGRATE
SDO_TUNE
TimeScale
TimeSeries
TSTools
UTL_PG
Vir_Pkg

2 DBMS_ALERT

Security
Constants
Errors
Using Alerts
Summary of Subprograms
REGISTER Procedure
REMOVE Procedure
REMOVEALL Procedure
SET_DEFAULTS Procedure
SIGNAL Procedure
WAITANY Procedure
WAITONE Procedure
Example

3 DBMS_APPLICATION_INFO

Summary of Subprograms
SET_MODULE Procedure
SET_ACTION Procedure
READ_MODULE Procedure
SET_CLIENT_INFO Procedure
READ_CLIENT_INFO Procedure
SET_SESSION_LONGOPS Procedure

4 DBMS_AQ

Java Classes
Enumerated Constants
Data Structures
Summary of Subprograms
ENQUEUE Procedure
DEQUEUE Procedure
LISTEN Procedure

5 DBMS_AQADM

Enumerated Constants
Summary of Subprograms
CREATE_QUEUE_TABLE Procedure
ALTER_QUEUE_TABLE Procedure
DROP_QUEUE_TABLE Procedure
CREATE_QUEUE Procedure
CREATE_NP_QUEUE Procedure
ALTER_QUEUE Procedure
DROP_QUEUE Procedure
START_QUEUE Procedure
STOP_QUEUE Procedure
GRANT_SYSTEM_PRIVILEGE Procedure
REVOKE_SYSTEM_PRIVILEGE Procedure
GRANT_QUEUE_PRIVILEGE Procedure
REVOKE_QUEUE_PRIVILEGE Procedure
ADD_SUBSCRIBER Procedure
ALTER_SUBSCRIBER Procedure
REMOVE_SUBSCRIBER Procedure
SCHEDULE_PROPAGATION Procedure
UNSCHEDULE_PROPAGATION Procedure
VERIFY_QUEUE_TYPES Procedure
ALTER_PROPAGATION_SCHEDULE Procedure
ENABLE_PROPAGATION_SCHEDULE Procedure
DISABLE_PROPAGATION_SCHEDULE Procedure
MIGRATE_QUEUE_TABLE Procedure

6 DBMS_BACKUP_RESTORE

Filename Normalization for Oracle on Windows NT Platforms

7 DBMS_DDL

Requirements
Summary of Subprograms
ALTER_COMPILE Procedure
ANALYZE_OBJECT Procedure

8 DBMS_DEBUG

Using DBMS_DEBUG
Usage Notes
Types
Constants
Error Codes
Exceptions
Variables
Summary of Subprograms
Common Section
PROBE_VERSION Procedure
SELF_CHECK Procedure
SET_TIMEOUT Function
TARGET SESSION Section
INITIALIZE Function
DEBUG_ON Procedure
DEBUG_OFF Procedure
Debug Session Section
ATTACH_SESSION Procedure
SYNCHRONIZE Function
SHOW_SOURCE Procedure
PRINT_BACKTRACE Procedure
CONTINUE Function
SET_BREAKPOINT Function
DELETE_BREAKPOINT Function
DISABLE_BREAKPOINT Function
ENABLE_BREAKPOINT Function
SHOW_BREAKPOINTS Procedure
GET_VALUE Function
SET_VALUE Function
DETACH_SESSION Procedure
GET_RUNTIME_INFO Function
GET_INDEXES Function
EXECUTE Procedure
PRINT_INSTANTIATIONS Procedure
TARGET_PROGRAM_RUNNING Procedure
PING Procedure
SET_TIMEOUT_BEHAVIOUR Procedure
OER Breakpoints

9 DBMS_DEFER

DBMS_DEFER Package
Summary of Subprograms
CALL Procedure
COMMIT_WORK Procedure
datatype_ARG Procedure
TRANSACTION Procedure

10 DBMS_DEFER_QUERY

DBMS_DEFER_QUERY Package
Summary of Subprograms
GET_ARG_FORM Function
GET_ARG_TYPE Function
GET_CALL_ARGS Procedure
GET_datatype_ARG Function

11 DBMS_DEFER_SYS

DBMS_DEFER_SYS Package
Summary of Subprograms
ADD_DEFAULT_DEST Procedure
DELETE_DEFAULT_DEST Procedure
DELETE_DEF_DESTINATION Procedure
DELETE_ERROR Procedure
DELETE_TRAN Procedure
DISABLED Function
EXCLUDE_PUSH Procedure
EXECUTE_ERROR Procedure
EXECUTE_ERROR_AS_USER Procedure
PURGE Function
PUSH Function
REGISTER_PROPAGATOR Procedure
SCHEDULE_PURGE Procedure
SCHEDULE_PUSH Procedure
SET_DISABLED Procedure
UNREGISTER_PROPAGATOR Procedure
UNSCHEDULE_PURGE Procedure
UNSCHEDULE_PUSH Procedure

12 DBMS_DESCRIBE

Security
Types
Errors
Summary of Subprograms
DESCRIBE_PROCEDURE Procedure
Examples

13 DBMS_DISTRIBUTED_TRUST_ADMIN

Requirements
Summary of Subprograms
ALLOW_ALL Procedure
ALLOW_SERVER Procedure
DENY_ALL Procedure
DENY_SERVER Procedure
Example

14 DBMS_HS

Exceptions
Summary of Subprograms
ALTER_BASE_CAPS Procedure
ALTER_BASE_DD Procedure
ALTER_CLASS_CAPS Procedure
ALTER_CLASS_DD Procedure
ALTER_CLASS_INIT Procedure
ALTER_FDS_CLASS Procedure
ALTER_FDS_INST Procedure
ALTER_INST_CAPS Procedure
ALTER_INST_DD Procedure
ALTER_INST_INIT Procedure
COPY_CLASS Procedure
COPY_INST Procedure
CREATE_BASE_CAPS Procedure
CREATE_BASE_DD Procedure
CREATE_CLASS_CAPS Procedure
CREATE_CLASS_DD Procedure
CREATE_CLASS_INIT Procedure
CREATE_FDS_CLASS Procedure
CREATE_FDS_INST Procedure
CREATE_INST_CAPS Procedure
CREATE_INST_DD Procedure
CREATE_INST_INIT Procedure
DROP_BASE_CAPS Procedure
DROP_BASE_DD Procedure
DROP_CLASS_CAPS Procedure
DROP_CLASS_DD Procedure
DROP_CLASS_INIT Procedure
DROP_FDS_CLASS Procedure
DROP_FDS_INST Procedure
DROP_INST_CAPS Procedure
DROP_INST_DD Procedure
DROP_INST_INIT Procedure
REPLACE_BASE_CAPS Procedure
REPLACE_BASE_DD Procedure
REPLACE_CLASS_CAPS Procedure
REPLACE_CLASS_DD Procedure
REPLACE_CLASS_INIT Procedure
REPLACE_FDS_CLASS Procedure
REPLACE_FDS_INST Procedure
REPLACE_INST_CAPS Procedure
REPLACE_INST_DD Procedure
REPLACE_INST_INIT Procedure

15 DBMS_HS_PASSTHROUGH

Security
Summary of Subprograms
BIND_VARIABLE Procedure
BIND_VARIABLE_RAW Procedure
BIND_OUT_VARIABLE Procedure
BIND_OUT_VARIABLE_RAW Procedure
BIND_INOUT_VARIABLE Procedure
BIND_INOUT_VARIABLE_RAW Procedure
CLOSE_CURSOR Procedure
EXECUTE_IMMEDIATE Procedure
EXECUTE_NON_QUERY Function
FETCH_ROW Function
GET_VALUE Procedure
GET_VALUE_RAW Procedure
OPEN_CURSOR Function
PARSE Procedure

16 DBMS_IOT

Summary of Subprograms
BUILD_CHAIN_ROWS_TABLE Procedure
BUILD_EXCEPTIONS_TABLE Procedure

17 DBMS_JOB

Requirements
Summary of Subprograms
SUBMIT Procedure
REMOVE Procedure
CHANGE Procedure
WHAT Procedure
NEXT_DATE Procedure
INSTANCE Procedure
INTERVAL Procedure
BROKEN Procedure
RUN Procedure
USER_EXPORT Procedure
USER_EXPORT Procedure
Using the DBMS_JOB Package with Oracle Parallel Server

18 DBMS_LOB

Requirements
LOB Locators
Datatypes
Constants
Exceptions
Security
Rules and Limitations
BFILE-Specific Rules and Limitations
Temporary LOBs
Temporary LOBs Usage Notes
Temporary LOB Exceptions
Summary of Subprograms
APPEND Procedure
CLOSE Procedure
COMPARE Function
COPY Procedure
CREATETEMPORARY Procedure
ERASE Procedure
FILECLOSE Procedure
FILECLOSEALL Procedure
FILEEXISTS Function
FILEGETNAME Procedure
FILEISOPEN Function
FILEOPEN Procedure
FREETEMPORARY Procedure
GETCHUNKSIZE Function
GETLENGTH Function
INSTR Function
ISOPEN Function
ISTEMPORARY Function
LOADFROMFILE Procedure
OPEN Procedure
READ Procedure
SUBSTR Function
TRIM Procedure
WRITE Procedure
WRITEAPPEND Procedure

19 DBMS_LOCK

Requirements
Security
Viewing and Monitoring Locks
Constants
Summary of Subprograms
ALLOCATE_UNIQUE Procedure
REQUEST Function
CONVERT Function
RELEASE Function
SLEEP Procedure
Example

20 DBMS_LOGMNR

Using the LogMiner
Constants
Using Place Holder Columns
Summary of Subprograms
ADD_LOGFILE Procedure
START_LOGMNR Procedure
END_LOGMNR Procedure
Example

21 DBMS_LOGMNR_D

Creating a Dictionary File
Summary of Subprograms
BUILD Procedure
Example

22 DBMS_MVIEW

DBMS_MVIEW as Synonym for DBMS_SNAPSHOT

23 DBMS_OBFUSCATION_TOOLKIT

DESEncrypt Procedure
Parameter Descriptions
Encryption Procedure Restriction
DESDecrypt Procedure
Parameter Descriptions
DESDecryption Procedure Restriction
DESEncryption and DESDecryption Code Example

24 DBMS_OFFLINE_OG

DBMS_OFFLINE_OG Package
Summary of Subprograms
BEGIN_INSTANTIATION Procedure
BEGIN_LOAD Procedure
END_INSTANTIATION Procedure
END_LOAD Procedure
RESUME_SUBSET_OF_MASTERS Procedure

25 DBMS_OFFLINE_SNAPSHOT

DBMS_OFFLINE_SNAPSHOT Package
Summary of Subprograms
BEGIN_LOAD Procedure
END_LOAD Procedure

26 DBMS_OLAP

Requirements
Error Messages
Summary of Subprograms
ESTIMATE_SUMMARY_SIZE Procedure
EVALUATE_UTILIZATION Procedure
EVALUATE_UTILIZATION_W Procedure
RECOMMEND_MV Procedure
RECOMMEND_MV_W Procedure
VALIDATE_DIMENSION Procedure
DBMS_OLAP Interface Tables

27 DBMS_ORACLE_TRACE_AGENT

Security
Summary of Subprograms
SET_ORACLE_TRACE_IN_SESSION Procedure
Example

28 DBMS_ORACLE_TRACE_USER

Summary of Subprograms
SET_ORACLE_TRACE Procedure
Example

29 DBMS_OUTPUT

Security
Errors
Types
Using DBMS_OUTPUT
Summary of Subprograms
ENABLE Procedure
DISABLE Procedure
PUT and PUT_LINE Procedures
NEW_LINE Procedure
GET_LINE and GET_LINES Procedures
Examples

30 DBMS_PCLXUTIL

Using DBMS_PCLXUTIL
Limitations
Summary of Subprograms
BUILD_PART_INDEX Procedure
Example

31 DBMS_PIPE

Public Pipes
Private Pipes
Pipe Uses
Security
Constants
Errors
Summary of Subprograms
CREATE_PIPE Function
PACK_MESSAGE Procedure
SEND_MESSAGE Function
RECEIVE_MESSAGE Function
NEXT_ITEM_TYPE Function
UNPACK_MESSAGE Procedure
REMOVE_PIPE Function
PURGE Procedure
RESET_BUFFER Procedure
UNIQUE_SESSION_NAME Function
Examples

32 DBMS_PROFILER

Using DBMS_PROFILER
Requirements
Collected Data
Security Considerations
Summary of Subprograms
Two Methods of Exception Generation
Exceptions
Error Codes
START_PROFILER Function
STOP_PROFILER Function
FLUSH_DATA Function
PAUSE_PROFILER Function
RESUME_PROFILER Function
GET_VERSION Procedure
INTERNAL_VERSION_CHECK Function

33 DBMS_RANDOM

Requirements
Summary of Subprograms
INITIALIZE Procedure
SEED Procedure
RANDOM Function
TERMINATE Procedure

34 DBMS_RECTIFIER_DIFF

DBMS_RECTIFIER_DIFF Package
Summary of Subprograms
DIFFERENCES Procedure
RECTIFY Procedure

35 DBMS_REFRESH

DBMS_REFRESH Package
Summary of Subprograms
ADD Procedure
CHANGE Procedure
DESTROY Procedure
MAKE Procedure
REFRESH Procedure
SUBTRACT Procedure

36 DBMS_REPAIR

Security
Enumeration Types
Exceptions
Summary of Subprograms
ADMIN_TABLES Procedure
CHECK_OBJECT Procedure
DUMP_ORPHAN_KEYS Procedure
FIX_CORRUPT_BLOCKS Procedure
REBUILD_FREELISTS Procedure
SKIP_CORRUPT_BLOCKS Procedure

37 DBMS_REPCAT

DBMS_REPCAT Package
Summary of Subprograms
ADD_GROUPED_COLUMN Procedure
ADD_MASTER_DATABASE Procedure
ADD_PRIORITY_datatype Procedure
ADD_SITE_PRIORITY_SITE Procedure
ADD_conflicttype_RESOLUTION Procedure
ALTER_MASTER_PROPAGATION Procedure
ALTER_MASTER_REPOBJECT Procedure
ALTER_PRIORITY Procedure
ALTER_PRIORITY_datatype Procedure
ALTER_SITE_PRIORITY Procedure
ALTER_SITE_PRIORITY_SITE Procedure
ALTER_SNAPSHOT_PROPAGATION Procedure
CANCEL_STATISTICS Procedure
COMMENT_ON_COLUMN_GROUP Procedure
COMMENT_ON_PRIORITY_GROUP/COMMENT_ON_SITE_PRIORITY Procedures
COMMENT_ON_REPGROUP Procedure
COMMENT_ON_REPOBJECT Procedure
COMMENT_ON_REPSITES Procedure
COMMENT_ON_SNAPSHOT_REPSITES Procedure
COMMENT_ON_conflicttype_RESOLUTION Procedure
COMPARE_OLD_VALUES Procedure
CREATE_MASTER_REPGROUP Procedure
CREATE_MASTER_REPOBJECT Procedure
CREATE_SNAPSHOT_REPGROUP Procedure
CREATE_SNAPSHOT_REPOBJECT Procedure
DEFINE_COLUMN_GROUP Procedure
DEFINE_PRIORITY_GROUP Procedure
DEFINE_SITE_PRIORITY Procedure
DO_DEFERRED_REPCAT_ADMIN Procedure
DROP_COLUMN_GROUP Procedure
DROP_GROUPED_COLUMN Procedure
DROP_MASTER_REPGROUP Procedure
DROP_MASTER_REPOBJECT Procedure
DROP_PRIORITY Procedure
DROP_PRIORITY_GROUP Procedure
DROP_PRIORITY_datatype Procedure
DROP_SITE_PRIORITY Procedure
DROP_SITE_PRIORITY_SITE Procedure
DROP_SNAPSHOT_REPGROUP Procedure
DROP_SNAPSHOT_REPOBJECT Procedure
DROP_conflicttype_RESOLUTION Procedure
EXECUTE_DDL Procedure
GENERATE_REPLICATION_SUPPORT Procedure
GENERATE_SNAPSHOT_SUPPORT Procedure
MAKE_COLUMN_GROUP Procedure
PURGE_MASTER_LOG Procedure
PURGE_STATISTICS Procedure
REFRESH_SNAPSHOT_REPGROUP Procedure
REGISTER_SNAPSHOT_REPGROUP Procedure
REGISTER_STATISTICS Procedure
RELOCATE_MASTERDEF Procedure
REMOVE_MASTER_DATABASES Procedure
REPCAT_IMPORT_CHECK Procedure
RESUME_MASTER_ACTIVITY Procedure
SEND_OLD_VALUES Procedure
SET_COLUMNS Procedure
SUSPEND_MASTER_ACTIVITY Procedure
SWITCH_SNAPSHOT_MASTER Procedure
UNREGISTER_SNAPSHOT_REPGROUP Procedure
VALIDATE Function
WAIT_MASTER_LOG Procedure

38 DBMS_REPCAT_ADMIN

DBMS_REPCAT_ADMIN Package
Summary of Subprograms
GRANT_ADMIN_ANY_SCHEMA Procedure
GRANT_ADMIN_SCHEMA Procedure
REGISTER_USER_REPGROUP Procedure
REVOKE_ADMIN_ANY_SCHEMA Procedure
REVOKE_ADMIN_SCHEMA Procedure
UNREGISTER_USER_REPGROUP Procedure

39 DBMS_REPCAT_INSTANTIATE

DBMS_REPCAT_INSTANTIATE Package
Summary of Subprograms
DROP_SITE_INSTANTIATION Procedure
INSTANTIATE_OFFLINE Function
INSTANTIATE_OFFLINE_REPAPI Function
INSTANTIATE_ONLINE Function

40 DBMS_REPCAT_RGT

DBMS_REPCAT_RGT Package
Summary of Subprograms
ALTER_REFRESH_TEMPLATE Procedure
ALTER_TEMPLATE_OBJECT Procedure
ALTER_TEMPLATE_PARM Procedure
ALTER_USER_AUTHORIZATION Procedure
ALTER_USER_PARM_VALUE Procedure
COMPARE_TEMPLATES Function
COPY_TEMPLATE Function
CREATE_OBJECT_FROM_EXISTING Function
CREATE_REFRESH_TEMPLATE Function
CREATE_TEMPLATE_OBJECT Function
CREATE_TEMPLATE_PARM Function
CREATE_USER_AUTHORIZATION Function
CREATE_USER_PARM_VALUE Function
DELETE_RUNTIME_PARMS Procedure
DROP_ALL_OBJECTS Procedure
DROP_ALL_TEMPLATE_PARMS Procedure
DROP_ALL_TEMPLATE_SITES Procedure
DROP_ALL_TEMPLATES Procedure
DROP_ALL_USER_AUTHORIZATIONS Procedure
DROP_ALL_USER_PARM_VALUES Procedure
DROP_REFRESH_TEMPLATE Procedure
DROP_SITE_INSTANTIATION Procedure
DROP_TEMPLATE_OBJECT Procedure
DROP_TEMPLATE_PARM Procedure
DROP_USER_AUTHORIZATION Procedure
DROP_USER_PARM_VALUE Procedure
GET_RUNTIME_PARM_ID Function
INSERT_RUNTIME_PARMS Procedure
INSTANTIATE_OFFLINE Function
INSTANTIATE_OFFLINE_REPAPI Function
INSTANTIATE_ONLINE Function
LOCK_TEMPLATE_EXCLUSIVE procedure
LOCK_TEMPLATE_SHARED procedure

41 DBMS_REPUTIL

DBMS_REPUTIL Package
Summary of Subprograms
REPLICATION_OFF Procedure
REPLICATION_ON Procedure
REPLICATION_IS_ON Function
FROM_REMOTE Function
GLOBAL_NAME Function
MAKE_INTERNAL_PKG Procedure
SYNC_UP_REP Procedure

42 DBMS_RESOURCE_MANAGER

Requirements
Summary of Subprograms
CREATE_PLAN Procedure
UPDATE_PLAN Procedure
DELETE_PLAN Procedure
DELETE_PLAN_CASCADE Procedure
CREATE_CONSUMER_GROUP Procedure
UPDATE_CONSUMER_GROUP Procedure
DELETE_CONSUMER_GROUP Procedure
CREATE_PLAN_DIRECTIVE Procedure
UPDATE_PLAN_DIRECTIVE Procedure
DELETE_PLAN_DIRECTIVE Procedure
CREATE_PENDING_AREA Procedure
VALIDATE_PENDING_AREA Procedure
CLEAR_PENDING_AREA Procedure
SUBMIT_PENDING_AREA Procedure
SET_INITIAL_CONSUMER_GROUP Procedure
SWITCH_CONSUMER_GROUP_FOR_SESS Procedure
SWITCH_CONSUMER_GROUP_FOR_USER Procedure

43 DBMS_RESOURCE_MANAGER_PRIVS

Summary of Subprograms
GRANT_SYSTEM_PRIVILEGE Procedure
REVOKE_SYSTEM_PRIVILEGE Procedure
GRANT_SWITCH_CONSUMER_GROUP Procedure
REVOKE_SWITCH_CONSUMER_GROUP Procedure

44 DBMS_RLS

Dynamic Predicates
Security
Usage Notes
Summary of Subprograms
ADD_POLICY Procedure
DROP_POLICY Procedure
REFRESH_POLICY Procedure
ENABLE_POLICY Procedure
Example

45 DBMS_ROWID

Usage Notes
Requirements
ROWID Types
Exceptions
Summary of Subprograms
ROWID_CREATE Function
ROWID_INFO Procedure
ROWID_TYPE Function
ROWID_OBJECT Function
ROWID_RELATIVE_FNO Function
ROWID_BLOCK_NUMBER Function
ROWID_ROW_NUMBER Function
ROWID_TO_ABSOLUTE_FNO Function
ROWID_TO_EXTENDED Function
ROWID_TO_RESTRICTED Function
ROWID_VERIFY Function

46 DBMS_SESSION

Requirements
Summary of Subprograms
SET_ROLE Procedure
SET_SQL_TRACE Procedure
SET_NLS Procedure
CLOSE_DATABASE_LINK Procedure
RESET_PACKAGE Procedure
UNIQUE_SESSION_ID Function
IS_ROLE_ENABLED Function
IS_SESSION_ALIVE Function
SET_CLOSE_CACHED_OPEN_CURSORS Procedure
FREE_UNUSED_USER_MEMORY Procedure
SET_CONTEXT Procedure
LIST_CONTEXT Procedure
SWITCH_CURRENT_CONSUMER_GROUP Procedure
Example

47 DBMS_SHARED_POOL

Installation Notes
Usage Notes
Summary of Subprograms
SIZES Procedure
KEEP Procedure
UNKEEP Procedure
ABORTED_REQUEST_THRESHOLD Procedure

48 DBMS_SNAPSHOT

DBMS_SNAPSHOT Package
Summary of Subprograms
BEGIN_TABLE_REORGANIZATION Procedure
END_TABLE_REORGANIZATION Procedure
I_AM_A_REFRESH Function
PURGE_DIRECT_LOAD_LOG Procedure
PURGE_LOG Procedure
PURGE_SNAPSHOT_FROM_LOG Procedure
REFRESH Procedure
REFRESH_ALL_MVIEWS Procedure
REFRESH_DEPENDENT Procedure
REGISTER_SNAPSHOT Procedure
UNREGISTER_SNAPSHOT Procedure

49 DBMS_SPACE

Security
Requirements
Summary of Subprograms
UNUSED_SPACE Procedure
FREE_BLOCKS Procedure
Examples

50 DBMS_SPACE_ADMIN

Security
Constants
Summary of Subprograms
SEGMENT_VERIFY Procedure
SEGMENT_CORRUPT Procedure
SEGMENT_DROP_CORRUPT Procedure
SEGMENT_DUMP Procedure
TABLESPACE_VERIFY Procedure
TABLESPACE_FIX_BITMAPS Procedure
TABLESPACE_REBUILD_BITMAPS Procedure
TABLESPACE_REBUILD_QUOTAS Procedure
TABLESPACE_MIGRATE_FROM_LOCAL Procedure
TABLESPACE_MIGRATE_TO_LOCAL Procedure
TABLESPACE_RELOCATE_BITMAPS Procedure
TABLESPACE_FIX_SEGMENT_STATES Procedure
Further Examples

51 DBMS_SQL

Using DBMS_SQL
Constants
Types
Exceptions
Execution Flow
Security
Summary of Subprograms
OPEN_CURSOR Function
PARSE Procedure
BIND_VARIABLE and BIND_ARRAY Procedures
Processing Queries
DEFINE_COLUMN Procedure
DEFINE_ARRAY Procedure
DEFINE_COLUMN_LONG Procedure
EXECUTE Function
EXECUTE_AND_FETCH Function
FETCH_ROWS Function
COLUMN_VALUE Procedure
COLUMN_VALUE_LONG Procedure
VARIABLE_VALUE Procedure
Processing Updates, Inserts and Deletes
IS_OPEN Function
DESCRIBE_COLUMNS Procedure
CLOSE_CURSOR Procedure
Locating Errors
LAST_ERROR_POSITION Function
LAST_ROW_COUNT Function
LAST_ROW_ID Function
LAST_SQL_FUNCTION_CODE Function
Examples

52 DBMS_STATS

Using DBMS_STATS
Types
Summary of Subprograms
Setting or Getting Statistics
PREPARE_COLUMN_VALUES Procedure
SET_COLUMN_STATS Procedure
SET_INDEX_STATS Procedure
SET_TABLE_STATS Procedure
CONVERT_RAW_VALUE Procedure
GET_COLUMN_STATS Procedure
GET_INDEX_STATS Procedure
GET_TABLE_STATS Procedure
DELETE_COLUMN_STATS Procedure
DELETE_INDEX_STATS Procedure
DELETE_TABLE_STATS Procedure
DELETE_SCHEMA_STATS Procedure
DELETE_DATABASE_STATS Procedure
Transferring Statistics
CREATE_STAT_TABLE Procedure
DROP_STAT_TABLE Procedure
EXPORT_COLUMN_STATS Procedure
EXPORT_INDEX_STATS Procedure
EXPORT_TABLE_STATS Procedure
EXPORT_SCHEMA_STATS Procedure
EXPORT_DATABASE_STATS Procedure
IMPORT_COLUMN_STATS Procedure
IMPORT_INDEX_STATS Procedure
IMPORT_TABLE_STATS Procedure
IMPORT_SCHEMA_STATS Procedure
IMPORT_DATABASE_STATS Procedure
Gathering Optimizer Statistics
GATHER_INDEX_STATS Procedure
GATHER_TABLE_STATS Procedure
GATHER_SCHEMA_STATS Procedure
GATHER_DATABASE_STATS Procedure
GENERATE_STATS Procedure
Example

53 DBMS_TRACE

Requirements
Restrictions
Constants
Using DBMS_TRACE
Summary of Subprograms
SET_PLSQL_TRACE Procedure
CLEAR_PLSQL_TRACE Procedure
PLSQL_TRACE_VERSION procedure

54 DBMS_TRANSACTION

Requirements
Summary of Subprograms
READ_ONLY Procedure
READ_WRITE Procedure
ADVISE_ROLLBACK Procedure
ADVISE_NOTHING Procedure
ADVISE_COMMIT Procedure
USE_ROLLBACK_SEGMENT Procedure
COMMIT_COMMENT Procedure
COMMIT_FORCE Procedure
COMMIT Procedure
SAVEPOINT Procedure
ROLLBACK Procedure
ROLLBACK_SAVEPOINT Procedure
ROLLBACK_FORCE Procedure
BEGIN_DISCRETE_TRANSACTION Procedure
PURGE_MIXED Procedure
PURGE_LOST_DB_ENTRY Procedure
LOCAL_TRANSACTION_ID Function
STEP_ID Function

55 DBMS_TTS

Exceptions
Summary of Subprograms
TRANSPORT_SET_CHECK Procedure
DOWNGRADE Procedure

56 DBMS_UTILITY

Requirements
Types
Summary of Subprograms
COMPILE_SCHEMA Procedure
ANALYZE_SCHEMA Procedure
ANALYZE_DATABASE Procedure
FORMAT_ERROR_STACK Function
FORMAT_CALL_STACK Function
IS_PARALLEL_SERVER Function
GET_TIME Function
GET_PARAMETER_VALUE Function
NAME_RESOLVE Procedure
NAME_TOKENIZE Procedure
COMMA_TO_TABLE Procedure
TABLE_TO_COMMA Procedure
PORT_STRING Function
DB_VERSION Procedure
MAKE_DATA_BLOCK_ADDRESS Function
DATA_BLOCK_ADDRESS_FILE Function
DATA_BLOCK_ADDRESS_BLOCK Function
GET_HASH_VALUE Function
ANALYZE_PART_OBJECT Procedure
EXEC_DDL_STATEMENT Procedure
CURRENT_INSTANCE Function
ACTIVE_INSTANCES Procedure

57 DEBUG_EXTPROC

Requirements
Installation Notes
Using DEBUG_EXTPROC
Summary of Subprograms
STARTUP_EXTPROC_AGENT Procedure

58 OUTLN_PKG

Requirements
Security
Summary of Subprograms
DROP_UNUSED Procedure
DROP_BY_CAT Procedure
UPDATE_BY_CAT Procedure

59 UTL_COLL

Summary of Subprograms
IS_LOCATOR Function
Example

60 UTL_FILE

Security
File Ownership and Protections
Examples (UNIX-Specific)
Types
Exceptions
Summary of Subprograms
FOPEN Function
IS_OPEN Function
FCLOSE Procedure
FCLOSE_ALL Procedure
GET_LINE Procedure
PUT Procedure
NEW_LINE Procedure
PUT_LINE Procedure
PUTF Procedure
FFLUSH Procedure
FOPEN Function

61 UTL_HTTP

Exceptions
Usage Notes
Summary of Subprograms
REQUEST Function
REQUEST_PIECES Function
Example

62 UTL_INADDR

Internet Address Package
get_host_name()
get_host_address()
Exceptions

63 UTL_RAW

Usage Notes
Summary of Subprograms
CONCAT Function
CAST_TO_RAW Function
CAST_TO_VARCHAR2 Function
LENGTH Function
SUBSTR Function
TRANSLATE Function
TRANSLITERATE Function
OVERLAY Function
COPIES Function
XRANGE Function
REVERSE Function
COMPARE Function
CONVERT Function
BIT_AND Function
BIT_OR Function
BIT_XOR Function
BIT_COMPLEMENT Function

64 UTL_REF

Requirements
Datatypes
Exceptions
Security
Summary of Subprograms
SELECT_OBJECT Procedure
LOCK_OBJECT Procedure
UPDATE_OBJECT Procedure
DELETE_OBJECT Procedure
Example

65 UTL_SMTP

connection
reply, replies
open_connection()
command(), command_replies()
helo()
ehlo()
mail()
rcpt()
data()
open_data(), write_data(), write_raw_data(), close_data()
rset()
vrfy()
noop()
quit()
Exceptions
Limitations
Reply Codes
Example

66 UTL_TCP

TCP/IP package (UTL_TCP)
connection
CRLF
open_connection()
available()
read_raw()
write_raw()
read_text()
write_text()
read_line()
write_line()
get_raw(), get_text(), get_line()
flush()
close_connection()
close_all_connections()
Exceptions
Example

Index


Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Index