 | Chapter 1 Oracle PL/SQL Built-ins Pocket Reference |
In addition to the definitions for the programs (shown earlier in the Section 1.3, "Built-in Packages" section), a package specification may contain nonprogram elements defined for that package. These elements may include constants, exceptions, record types, and index-by tables.
This section shows the nonprogram elements defined for each of the built-in packages.
maxwait CONSTANT INTEGER := 86400000;
set_session_longops_nohint CONSTANT BINARY_INTEGER := -1;
before CONSTANT BINARY_INTEGER
browse CONSTANT BINARY_INTEGER
expired CONSTANT BINARY_INTEGER
first_message CONSTANT BINARY_INTEGER
forever CONSTANT BINARY_INTEGER
immediate CONSTANT BINARY_INTEGER
locked CONSTANT BINARY_INTEGER
never CONSTANT BINARY_INTEGER
next_message CONSTANT BINARY_INTEGER
next_transaction CONSTANT BINARY_INTEGER
no_delay CONSTANT BINARY_INTEGER
no_wait CONSTANT BINARY_INTEGER
on_commit CONSTANT BINARY_INTEGER
processed CONSTANT BINARY_INTEGER
ready CONSTANT BINARY_INTEGER
remove CONSTANT BINARY_INTEGER
top CONSTANT BINARY_INTEGER
waiting CONSTANT BINARY_INTEGER
TYPE aq$_recipient_list_t IS TABLE OF sys.aq$_agent
INDEX BY BINARY_INTEGER;
TYPE message_properties_t IS RECORD
(priority BINARY_INTEGER DEFAULT 1
,delay BINARY_INTEGER
DEFAULT DBMS_AQ.no_delay
,expiration BINARY_INTEGER
DEFAULT DBMS_AQ.never
,correlation VARCHAR2(128) DEFAULT NULL
,attempts BINARY_INTEGER
,recipient_list DBMS_AQ.aq$_recipient_list_t
,exception_queue VARCHAR2(51) DEFAULT NULL
,enqueue_time DATE
,state BINARY_INTEGER);
TYPE enqueue_options_t IS RECORD
(visibility BINARY_INTEGER
DEFAULT DBMS_AQ.on_commit
,relative_msgid RAW(16) DEFAULT NULL
,sequence_deviation BINARY_INTEGER DEFAULT NULL);
TYPE dequeue_options_t IS RECORD
(consumer_name VARCHAR2(30) DEFAULT NULL
,dequeue_mode BINARY_INTEGER
DEFAULT DBMS_AQ.remove
,navigation BINARY_INTEGER
DEFAULT DBMS_AQ.next_message
,visibility BINARY_INTEGER
DEFAULT DBMS_AQ.on_commit
,wait BINARY_INTEGER
DEFAULT DBMS_AQ.forever
,msgid RAW(16) DEFAULT NULL
,correlation VARCHAR2(128) DEFAULT NULL);exception_queue CONSTANT BINARY_INTEGER := 1; infinite CONSTANT BINARY_INTEGER := -1; none CONSTANT BINARY_INTEGER := 0; normal_queue CONSTANT BINARY_INTEGER := 0; transactional CONSTANT BINARY_INTEGER := 1; TYPE aq$_subscriber_list_t IS TABLE OF sys.aq$_agent INDEX BY BINARY_INTEGER;
TYPE varchar2_table IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER; TYPE number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
invalid_argval EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_argval, -21560); access_error EXCEPTION; PRAGMA EXCEPTION_INIT(access_error, -22925); noexist_directory EXCEPTION; PRAGMA EXCEPTION_INIT(noexist_directory, -22285); nopriv_directory EXCEPTION; PRAGMA EXCEPTION_INIT(nopriv_directory, -22286); invalid_directory EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_directory, -22287); operation_failed EXCEPTION; PRAGMA EXCEPTION_INIT(operation_failed, -22288); unopened_file EXCEPTION; PRAGMA EXCEPTION_INIT(unopened_file, -22289); open_toomany EXCEPTION; PRAGMA EXCEPTION_INIT(open_toomany, -22290); file_readonly CONSTANT BINARY_INTEGER := 0; lobmaxsize CONSTANT INTEGER := 4294967295; invalid_argval_num NUMBER := 21560; access_error_num NUMBER := 22925; noexist_directory_num NUMBER := 22285; nopriv_directory_num NUMBER := 22286; invalid_directory_num NUMBER := 22287; operation_failed_num NUMBER := 22288; unopened_file_num NUMBER := 22289; open_toomany_num NUMBER := 22290;
nl_mode CONSTANT INTEGER := 1; ss_mode CONSTANT INTEGER := 2; sx_mode CONSTANT INTEGER := 3; s_mode CONSTANT INTEGER := 4; ssx_mode CONSTANT INTEGER := 5; x_mode CONSTANT INTEGER := 6; maxwait CONSTANT INTEGER := 32767;
TYPE chararr IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
maxwait CONSTANT INTEGER := 86400000;
rowid_invalid EXCEPTION; PRAGMA EXCEPTION_INIT(rowid_invalid, -1410); rowid_bad_block EXCEPTION; PRAGMA EXCEPTION_INIT(rowid_bad_block, -28516); rowid_convert_external CONSTANT INTEGER := 1; rowid_convert_internal CONSTANT INTEGER := 0; rowid_is_invalid CONSTANT INTEGER := 1; rowid_is_valid CONSTANT INTEGER := 0; rowid_object_undefined CONSTANT INTEGER := 0; rowid_type_extended CONSTANT INTEGER := 1; rowid_type_restricted CONSTANT INTEGER := 0;
inconsistent_type EXCEPTION; PRAGMA EXCEPTION_INIT(inconsistent_type, -6562); v6 CONSTANT INTEGER := 0; native CONSTANT INTEGER := 1; v7 CONSTANT INTEGER := 2; TYPE varchar2s IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER; TYPE desc_rec IS RECORD (col_type BINARY_INTEGER := 0 ,col_max_len BINARY_INTEGER := 0 ,col_name varchar2(32) := '' ,col_name_len BINARY_INTEGER := 0 ,col_schema_name VARCHAR2(32) := '' ,col_schema_name_len BINARY_INTEGER := 0 ,col_precision BINARY_INTEGER := 0 ,col_scale BINARY_INTEGER := 0 ,col_charsetid BINARY_INTEGER := 0 ,col_charsetform BINARY_INTEGER := 0 ,col_null_ok BOOLEAN := TRUE); TYPE desc_tab IS TABLE OF desc_rec INDEX BY BINARY_INTEGER; TYPE number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; TYPE varchar2_table IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER; TYPE date_table IS TABLE OF DATE INDEX BY BINARY_INTEGER; TYPE blob_table IS TABLE OF BLOB INDEX BY BINARY_INTEGER; TYPE clob_table IS TABLE OF CLOB INDEX BY BINARY_INTEGER; TYPE bfile_table IS TABLE OF BFILE INDEX BY BINARY_INTEGER;
discrete_transaction_failed EXCEPTION;
-8175);
consistent_read_failure EXCEPTION;
PRAGMA EXCEPTION_INIT(consistent_read_failure, -8176);TYPE uncl_array IS TABLE OF VARCHAR2(227) INDEX BY BINARY_INTEGER; TYPE name_array IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER; TYPE dblink_array IS TABLE OF VARCHAR2(128) INDEX BY BINARY_INTEGER; TYPE index_table_type IS TABLE OF BINARY_INTEGER INDEX BY BINARY_INTEGER; TYPE number_array IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
internal_error EXCEPTION; invalid_filehandle EXCEPTION; invalid_mode EXCEPTION; invalid_operation EXCEPTION; invalid_path EXCEPTION; read_error EXCEPTION; write_error EXCEPTION; TYPE file_type IS RECORD (id BINARY_INTEGER);
Following are the nonprogram elements for the STANDARD package.
dup_val_on_index EXCEPTION; PRAGMA EXCEPTION_INIT(dup_val_on_index, '-0001'); timeout_on_resource EXCEPTION; PRAGMA EXCEPTION_INIT(timeout_on_resource, '-0051'); invalid_cursor EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_cursor, '-1001'); not_logged_on EXCEPTION; PRAGMA EXCEPTION_INIT(not_logged_on, '-1012'); login_denied EXCEPTION; PRAGMA EXCEPTION_INIT(login_denied, '-1017'); too_many_rows EXCEPTION; PRAGMA EXCEPTION_INIT(too_many_rows, '-1422'); zero_divide EXCEPTION; PRAGMA EXCEPTION_INIT(zero_divide, '-1476'); invalid_number EXCEPTION; PRAGMA EXCEPTION_INIT(invalid_number, '-1722'); storage_error EXCEPTION; PRAGMA EXCEPTION_INIT(storage_error, '-6500'); program_error EXCEPTION; PRAGMA EXCEPTION_INIT(program_error, '-6501'); value_error EXCEPTION; PRAGMA EXCEPTION_INIT(value_error, '-6502'); rowtype_mismatch EXCEPTION; PRAGMA EXCEPTION_INIT(rowtype_mismatch, '-6504'); cursor_already_open EXCEPTION; PRAGMA EXCEPTION_INIT(cursor_already_open, '-6511'); access_into_null EXCEPTION; PRAGMA EXCEPTION_INIT(access_into_null, '-6530'); collection_is_null EXCEPTION; PRAGMA EXCEPTION_INIT(collection_is_null , '-6531'); subscript_outside_limit EXCEPTION; PRAGMA EXCEPTION_INIT(subscript_outside_limit,'-6532'); subscript_beyond_count EXCEPTION; PRAGMA EXCEPTION_INIT(subscript_beyond_count ,'-6533'); no_data_found EXCEPTION; PRAGMA EXCEPTION_INIT(no_data_found, 100);
TYPE NUMBER IS NUMBER_BASE;
SUBTYPE BINARY_INTEGER IS INTEGER RANGE '-
2147483647'..2147483647;
SUBTYPE CURSOR_HANDLE IS BINARY_INTEGER RANGE 0..255;
SUBTYPE DEC IS DECIMAL;
SUBTYPE DECIMAL IS NUMBER(38,0);
SUBTYPE "DOUBLE PRECISION" IS FLOAT;
SUBTYPE FLOAT IS NUMBER; -- NUMBER(126)
SUBTYPE INT IS INTEGER;
SUBTYPE INTEGER IS NUMBER(38,0);
SUBTYPE NATURAL IS BINARY_INTEGER RANGE 0..2147483647;
SUBTYPE NATURALN IS NATURAL NOT NULL;
SUBTYPE NUMERIC IS DECIMAL;
SUBTYPE PLS_INTEGER IS BINARY_INTEGER;
SUBTYPE POSITIVE IS BINARY_INTEGER RANGE
1..2147483647;
SUBTYPE POSITIVEN IS POSITIVE NOT NULL;
SUBTYPE REAL IS FLOAT; -- FLOAT(63)
SUBTYPE SIGNTYPE IS BINARY_INTEGER RANGE '-1'..1; --
for SIGN functions
SUBTYPE SMALLINT IS NUMBER(38,0);TYPE VARCHAR2 IS NEW CHAR_BASE;
SUBTYPE CHAR IS VARCHAR2;
SUBTYPE CHARACTER IS CHAR;
SUBTYPE "CHAR VARYING" IS VARCHAR;
SUBTYPE "CHARACTER VARYING" IS VARCHAR;
SUBTYPE LONG IS VARCHAR2(32760);
SUBTYPE "LONG RAW" IS RAW(32760);
SUBTYPE RAW IS VARCHAR2;
SUBTYPE ROWID IS VARCHAR2(256);
SUBTYPE STRING IS VARCHAR2;
SUBTYPE VARCHAR IS VARCHAR2;
SUBTYPE "NCHAR" IS CHAR CHARACTER SET NCHAR_CS;
SUBTYPE "NCHAR VARYING" IS VARCHAR CHARACTER SET
NCHAR_CS;
SUBTYPE "NCLOB" IS CLOB CHARACTER SET NCHAR_CS;
SUBTYPE "NVARCHAR2" IS VARCHAR2 CHARACTER SET NCHAR_CS;
SUBTYPE "NATIONAL CHAR VARYING" IS
VARCHAR CHARACTER SET NCHAR_CS;
SUBTYPE "NATIONAL CHAR" IS CHAR CHARACTER SET NCHAR_CS;
SUBTYPE "NATIONAL CHARACTER LARGE OBJECT" IS
CLOB CHARACTER SET NCHAR_CS;
SUBTYPE "NATIONAL CHARACTER VARYING" IS
VARCHAR CHARACTER SET NCHAR_CS;
SUBTYPE "NATIONAL CHARACTER" IS
CHAR CHARACTER SET NCHAR_CS;
SUBTYPE "NCHAR LARGE OBJECT" IS
CLOB CHARACTER SET NCHAR_CS;TYPE BFILE IS BFILE_BASE; TYPE BLOB IS BLOB_BASE; TYPE CLOB IS CLOB_BASE; SUBTYPE "BINARY LARGE OBJECT" IS BLOB; SUBTYPE "CHAR LARGE OBJECT" IS CLOB; SUBTYPE "CHARACTER LARGE OBJECT" IS CLOB;
TYPE BOOLEAN IS (FALSE, TRUE); TYPE DATE IS DATE_BASE; TYPE MLSLABEL IS NEW CHAR_BASE;
|  | |
| 1.5 RESTRICT REFERENCES Pragmas |
Copyright (c) 2000 O'Reilly & Associates. All rights reserved.