Built-in Packages Oracle 8i
1. DBMS_ALERT
2. DBMS_APPLICATION_INFO
3. DBMS_AQ
4. DBMS_AQADM
5. DBMS_DDL
6. DMBS_DESCRIBE
7. DBMS_JOB
8. DBMS_LOB
9. DBMS_LOCK
10. DBMS_OUTPUT
11 DBMS_PIPE
12. DBMS_RANDOM
13. DBMS_ROWID
14. DBMS_SESSION
15. DBMS_SHARED_POOL
16. DBMS_SPACE
17. DBMS_SQL
18. DBMS_STANDARD
19. DBMS_SYSTEM
20. DBMS_TRANSACTION
21. DBMS_UTILITY
22. UTL_FILE
23. UTL_RAW
24. UTL_REF
PROCEDURE DBMS_ALERT.REGISTER
( name IN VARCHAR2 );
PROCEDURE DBMS_ALERT.REMOVE
( name IN VARCHAR2 )
PROCEDURE DBMS_ALERT.REMOVALL;
PROCEDURE DBMS_ALERT.SET_DEFAULTS
( sensitivity IN NUMBER );
PROCEDURE DBMS_ALERT.SIGNAL
( name IN VARCHAR2 ,message IN VARCHAR2 );
PROCEDURE DBMS_ALERT.WAITANY
( name OUT VARCHAR2,message OUT VARCHAR2,
status OUT INTEGER, timeout IN NUMBER DEFAULT MAXWAIT );
PROCEDURE DBMS_ALERT.WAITTONE
( name IN VARCHAR2,message OUT VARCHAR2,status OUT INTEGER,
timeout IN NUMBER DEFAULT MAXWAIT );
PROCEDURE DBMS_APPLICATION_INFO.READ_CLIENT_INFO
( client_info OUT VARCHAR2 );
PROCEDURE DBMS_APPLICATION_INFO.READ_MODULE
( module_name OUT VARCHAR2,action_name OUT VARCHAR2 );
PROCEDURE DBMS_APPLICATION_INFO.SET_ACTION
( action_name IN VARCHAR2 );
PROCEDURE DBMS_APPLICATION_INFO.SET_CLIENT_INFO
( client_info IN VARCHAR2 );
PROCEDURE DBMS_APPLICATION_INFO.SET_MODULE
( module_name IN VARCHAR2,action_name IN VARCHAR2 );
PROCEDURE DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS
( hint IN OUT BINARY_INTEGER,context IN NUMBER DEFAULT 0,
stapid IN NUMBER DEFAULT 0,stepofar IN NUMBER DEFAULT 0,
steptotal IN NUMBER DEFAULT 0,sofar IN NUMBER DEFAULT 0,
totalwork IN NUMBER DEFAULT 0,application_data_1 IN NUMBER DEFAULT 0,
application_data_2 IN NUMBER DEFAULT 0, application_data_3 IN NUMBER DEFAULT 0
);
3. DBMS_AQ
PROCEDURE DBMS_AQ.ENQUEUE
( queue_name IN VARCHAR2,enqueue_options IN DBMS_AQ.ENQUEUE_OPTIONS_T,
message_properties IN DBMS_AQ.MESSAGE_PROPERTIES_T,payload IN payload_type,
msgid OUT RAW );
PROCEDURE DBMS_AQ.DEQUEUE
( queue_name IN VARCHAR2,dequeue_options IN DBMS_AQ.DEQUEUE_OPTIONS_T,
message_properties OUT DBMS_AQ.MESSAGE_PROPERTIES_T,
payload OUT <payload_type>,msgid OUT RAW );
PROCEDURE DBMS_AQADM.CREATE_QUEUE_TABLE
( queue_table IN VARCHAR2
,queue_payload_type IN VARCHAR2
,storage_clause IN VARCHAR2 DEFAULT NULL
,sort_list IN VARCHAR2 DEFAULT NULL
,multiple_consumers IN BOOLEAN DEFAULT FALSE
,message_grouping IN BINARY_INTEGER DEFAULT NONE
,comment IN VARCHAR2 DEFAULT NULL
,auto_commit IN BOOLEAN DEFAULT TRUE );
PROCEDURE DBMS_AQADM.CREATE_QUEUE
( queue_name IN VARCHAR2
,queue_table IN VARCHAR2
,queue_type IN BINARY_INTEGER DEFAULT NORMAL_QUEUE
,max_retries IN NUMBER DEFAULT 0
,retry_delay IN NUMBER DEFAULT 0
,retention_time IN NUMBER DEFAULT 0
,dependency_tracking IN BOOLEAN DEFAULT FALSE
,comment IN VARCHAR2 DEFAULT NULL
,auto_commit IN BOOLEAN DEFAULT TRUE );
PROCEDURE DBMS_AQADM.DROP_QUEUE
(queue_name IN VARCHAR2
,auto_commit IN BOOLEAN DEFAULT TRUE );
PROCEDURE DBMS_AQADM.DROP_QUEUE_TABLE
( queue_table IN VARCHAR2
,force IN BOOLEAN DEFAULT FALSE
,auto_commit IN BOOLEAN DEFAULT TRUE );
PROCEDURE DBMS_AQADM.START_QUEUE
(queue_name IN VARCHAR2
,enqueue IN BOOLEAN DEFAULT TRUE
,dequeue IN BOOLEAN DEFAULT TRUE
PROCEDURE DBMS_AQADM.STOP_QUEUE
( queue_name IN VARCHAR2
,enqueue IN BOOLEAN DEFAULT TRUE
,dequeue IN BOOLEAN DEFAULT TRUE
,wait IN BOOLEAN DEFAULT TRUE );
PROCEDURE DBMS_AQADM.ALTER_QUEUE
( queue_name IN VARCHAR2
,max_retries IN NUMBER DEFAULT NULL
,retry_delay IN NUMBER DEFAULT NULL
,retention_time IN NUMBER DEFAULT NULL
,auto_commit IN BOOLEAN DEFAULT TRUE );
PROCEDURE DBMS_AQADM.ADD_SUBSCRIBER
( queue_name IN VARCHAR2
,subscriber IN SYS.AQ$_AGENT );
PROCEDURE DBMS_AQADM.REMOVE_SUBSCRIBER
( queue_name IN VARCHAR2
,subscriber IN SYS.AQ$_AGENT );
PROCEDURE DBMS_AQADM.GRANT_TYPE_ACCESS
( user_name IN VARCHAR2 );
FUNCTION DBMS_AQADM.QUEUE_SUBSCRIBERS
( queue_name IN VARCHAR2 )
RETURN AQ$_SUBSCRIBER_LIST_T;
PROCEDURE DBMS_AQADM.START_TIME_MANAGER;
PROCEDURE DBMS_AQADM.STOP_TIME_MANAGER;
PROCEDURE DBMS_DLL.ALTER_COMPILE
( type IN VARCHAR2
,schema IN VARCHAR2
,name IN VARCHAR2 );
PROCEDURE DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE
( table_name IN VARCHAR2
,table_schema IN VARCHAR2 DEFAULT NULL
,affected_schema IN VARCHAR2 DEFAULT NULL );
PROCEDURE DBMS_DDL.ALTER_TABLE_REFERENCEABLE
( table_name IN VARCHAR2
,affected_schema IN VARCHAR2 DEFAULT NULL
,affected_schema IN VARCHAR2 DEFAULT NULL );
PROCEDURE DBMS_DLL.ANALYZE_OBJECT
( type IN VARCHAR2
,schema IN VARCHAR2
,method IN VARCHAR2
,estimate_rows IN NUMBER DEFAULT NULL
,estimate_percent IN NUMBER DEFAULT NULL
,method_opt IN VARCHAR2 DEFAULT NULL );
PROCEDURE DBMS_DESCRIBE.DESCRIBE_PROCEDURE
( object_name IN VARCHAR2
,reserved1 IN VARCHAR2
,reserved2 IN VARCHAR2
,overload OUT DBMS_DESCRIBE.NUMBER_TABLE
,position OUT DBMS_DESCRIBE.NUMBER_TABLE
,level OUT DBMS_DESCRIBE.NUMBER_TABLE
,argument_name OUT DBMS_DESCRIBE.VARCHAR2_TABLE
,datatype OUT DBMS_DESCRIBE.NUMBER_TABLE
,default_value OUT DBMS_DESCRIBE.NUMBER_TABLE
,in_out OUT DBMS_DESCRIBE.NUMBER_TABLE
,length OUT DBMS_DESCRIBE.NUMBER_TABLE
,precision OUT DBMS_DESCRIBE.NUMBER_TABLE
,scale OUT DBMS_DESCRIBE.NUMBER_TABLE
,radix OUT DBMS_DESCRIBE.NUMBER_TABLE
,spare OUT DBMS_DESCRIBE.NUMBER_TABLE );
PROCEDURE DBMS_JOB.BROKEN
( job IN BINARY_INTEGER
,broken IN BOOLEAN
,next_date IN DATE DEFAULT SYSDATE );
PROCEDURE DBMS_JOB.CHANGE
( job IN BINARY_INTEGER
,what IN VARCHAR2
,next_date IN DATE
,interval IN VARCHAR2 );
PROCEDURE DBMS_JOB.INTERVAL
( job IN BINARY_INTEGER
,interval IN VARCHAR2 );
PROCEDURE DBMS_JOB.ISUBMIT
( job IN BINARY_INTEGER
,what IN VARCHAR2
,next_date IN VARCHAR2
,interval IN VARCHAR2 DEFAULT 'null'
,no_parse IN BOOLEAN DEFAULT FALSE );
PROCEDURE DBMS_JOB.NEXT_DATE
( job IN BINARY_INTEGER
,next_date IN DATE );
PROCEDURE DBMS_JOB.REMOVE
( job IN BINARY_INTEGER );
PROCEDURE DBMS_JOB.RUN
( job IN BINARY_INTEGER );
PROCEDURE DBMS_JOB.SUBMIT
( job OUT BINARY_INTEGER
,what IN VARCHAR2
,next_date IN DATE DEFAULT SYSDATE
,interval IN VARCHAR2 DEFAULT 'null'
,no_parse IN BOOLEAN DEFAULT FALSE );
PROCEDURE DBMS_JOB.USER_EXPORT
( job IN BINARY_INTEGER
,mycall IN OUT VARCHAR2 );
PROCEDURE DBMS_JOB.WHAT
( job IN BINARY_INTEGER
.what IN VARCHAR2 );
PROCEDURE DBMS_LOB.APPEND
( dest_lob IN OUT BLOB
,src_lob IN BLOB );
PROCEDURE DBMS_LOB.APPEND
( dest_lob IN OUT CLOB CHARACTER SET ANY_CS
,src_lob IN CLOB CHARACTER SET dest_lob%CHARSET );
FUNCTION DBMS_LOB.COMPARE
( lob_1 IN BLOB | CLOB CHARACTER SET ANY_CS
,lob_2 IN BLOB | CLOB CHARACTER SET lob_1%CHARSET
,amount IN INTEGER := 4294967295
,offset_1 IN INTEGER := 1
,offset_2 IN INTEGER := 1 )
RETURN INTEGER;
FUNCTION DBMS_LOB.COMPARE
( file_1 IN BFILE
,file_2 IN BFILE
,amount IN INTEGER
,offset_1 IN INTEGER := 1
,offset_2 IN INTEGER := 1 )
RETURN INTEGER;
PROCEDURE DBMS_LOB.COPY
( dest_lob IN OUT BLOB;
,src_lob IN BLOB
,amount IN INTEGER
,dest_offset IN INTEGER := 1
,src_offset IN INTEGER := 1 );
PROCEDURE DBMS_LOB.COPY
( dest_lob IN OUT CLOB CHARACTER SET ANY_CS
,src_lob IN CLOB CHARACTER SET dest_lob%CHARSET,
,amount IN INTEGER
,dest_offset IN INTEGER := 1
,src_offset IN INTEGER := 1 );
PROCEDURE DBMS_LOB.ERASE
( lob_loc IN OUT BLOB | CLOB CHARACTER SET ANY_CS
,amount IN OUT INTEGER
,offset IN INTEGER := 1 );
PROCEDURE DBMS_LOB.FILECLOSE
( file_loc IN OUT BFILE );
PROCEDURE DBMS_LOB.FULECLOSEALL;
FUNCTION DMBS_LOB.FULEEXISTS
( file_loc IN BFILE )
RETURN INTEGER;
PROCEDURE DBMS_LOB.FILEGETNAME
( file_loc IN BFILE
,dir_alias OUT VARCHAR2
, filename OUT VARCHAR2 );
FUNCTION DBMS_LOB.FILEIOPEN
( file_loc IN BFILE )
RETURN INTEGER;
PROCEDURE DBMS_LOB.FILEOPEN
( file_loc IN OUT BFILE
,open_mode IN BINARY_INTEGER := FILE READONLY );
FUNCTION DBMS_LOB.GETLENGTH
( lob_loc IN BLOB )
RETURN INTEGER;
FUNCTION DBMS_LOB.GETLENGTH
( lob_loc IN CLOB CHARACTER SET ANY_CS )
RETURN INTEGER;
FUNCTION DBMS_LOB.GETLENGTH
( lob_loc IN BFILE )
RETURN INTEGER;
FUNCTION DMBS_LOB.INSTR
( lob_loc IN BLOB | BFILE
, pattern IN RAW
,offset IN INTEGER := 1
,nth IN INTEGER := 1 )
RETURN INTEGER;
FUNCTION DMBS_LOB.INSTR
( lob_loc IN CLOB CHARACTER SET ANY_CS
,pattern IN VARCHAR2 CHARACTER SET lob_loc%CHARSET
,offset IN INTEGER := 1
,nth IN INTEGER := 1)
RETURN INTEGER;
PROCEDURE DBMS_LOB.LOADFROMFILE
( dest_lob IN OUT BLOB | CLOB CHARACTER SET ANY_CS
,src_lob IN BFILE
,amount IN INTEGER
,dest_offset IN INTEGER := 1
,src_offset IN INTEGER := 1 );
PROCEDURE DMBS_LOB.READ
( lob_loc IN BLOB | BFILE
,amount IN OUT BINARY_INTEGER
,offset IN INTEGER
,buffer OUT RAW );
PROCEDURE DBMS_LOB.READ
( lob_loc IN CLOB CHARACTER SET ANY_CS
,amount IN OUT BINARY_INTEGER
,offset IN INTEGER
,buffer OUT VARCHAR2 CHARACTER SET lob_loc%CHARSET );
FUNCTION DMBS_LOB.SUBSTR
( lob_loc IN BLOB | BFILE
.amount IN INTEGER := 32767
.offset IN INTEGER := 1 )
RETURN RAW;
FUNCTION DMBS_LOB.SUBSTR
( lob_loc IN CLOB CHARACTER SET ANY_CS
.amount IN INTEGER := 32767
.offset IN INTEGER := 1 )
RETURN VARCHAR2 CHARACTER SET lob_loc%CHARSET;
PROCEDURE DMBS_LOB.TRIM
( lob_loc IN OUT BLOB | CLOB CHARACTER SET ANY_CS
,newlen IN INTEGER );
PROCEDURE DBMS_LOB.WRITE
( lob_loc IN OUT CLOB CHARACTER SET ANY_CS
,amount IN BINARY_INTEGER
,offset IN INTEGER
,buffer IN VARCHAR2 CHARACTER SET lob_loc%CHARSET );
PROCEDURE DBMS_LOCK.ALLOCATE_UNIQUE
( lockname IN VARCHAR2
,lockhandle OUT VARCHAR2
,eqpiration_secs IN VARCHAR DEFAULT 864000 );
FUNCTION DBMS_LOCK.CONVERT
( id IN INTEGER | lockhandle IN VARCHAR2
,lockmode IN INTEGER
,timeout IN NUMBER DEFAULT MAXWAIT )
RETURN INTEGER;
FUNCTION DBMS_LOCK.RELEASE
( id IN INTEGER | lockhandle IN VARCHAR2 )
RETURN INTEGER;
FUNCTION DBMS_LOCK.REQUEST
( id IN INTEGER | lockhandle IN VARCHAR2
,lockmode IN INTEGER DEFAULT X_MODE
,timeout IN INTEGER DEFAULT MAXWAIT
,release_on_commit IN BOOLEAN DEFAULT FALSE )
RETURN INTEGER;
PROCEDURE DBMS_LOCK.SLEEP
( seconds IN NUMBER );
PROCEDURE DBMS_OUTPUT.DISABLE;
PROCEDURE DBMS_OUTPUT.ENABLE
( buffer_size IN INTEGER DEFAULT 20000 );
PROCEDURE DBMS_OUTPUT.GET_LINE
( line OUT VARCHAR2
,status OUT INTEGER );
PROCEDURE DBMS_OUTPUT.GET_LINES
( lines OUT DBMS_OUTPUT.CHARARR
,numlines IN OUT INTEGER );
PROCEDURE DBMS_OUTPUT.NEW_LINE;
PROCEDURE DBMS_OUTPUT.PUT
( a IN DATE | NUMBER | VARCHAR2 );
PROCEDURE DBMS_OUTPUT.PUT_LINE
( a IN DATE | NUMBER | VARCHAR2 );
FUNCTION DBMS_PIPE.CREATE_PIPE
( pipename IN VARCHAR"
,maxpipesitze IN INTEGER DEFAULT 8192
,private IN BOOLEAN DEFAULT TRUE )
RETURN INTEGER;
FUNCTION DBMS_PIPE.NEXT_ITEM_TYPE
RETURN INTEGER;
PROCEDURE DBMS_PIPE.PACK_MESSAGE
( item IN VARCHAR2 | NUMBER | DATE );
PROCEDURE DBMS_PIPE.PACK_MESSAGE_RAW
( item IN RAW );
PROCEDURE DBMS_PIPE.PACK_MESSAGE_ROWID
( item IN ROWID );
PROCEDURE DBMS_PIPE.PURGE
( pipename IN VARCHAR2 );
FUNCTION DBMS_PIPE.RECEIVE_MESSAGE
( pipename IN VARCHAR2
,timeout IN INTEGER DEFAULT MAXWAIT )
RETURN INTEGER;
FUNCTION DBMS_PIPE.REMOVE_PIPE
( pipename IN VARCHAR2 )
RETURN INTEGER
PROCEDURE DBMS_PIPE.RESET_BUFFER;
FUNCTION DBMS_PIPE.SEND_MESSAGE
( pipename IN VARCHAR2
,timeout IN INTEGER DEFAULT MAXWAIT
,maxpipesize IN INTEGER DEFAULT 8192 )
RETURN INTEGER;
FUNCTION DBMS_PIPE.UNIQUE_SESSION_NAME
RETURN VARCHAR2;
PROCEDURE DBMS_PIPE.UNPACK_MESSAGE
( item OUT VARCHAR2 | NUMBER | DATE );
PROCEDURE DBMS_PIPE.UNPACK_MESSAGE_RAW
( item OUT RAW );
PROCEDURE DBMS_PIPE.UNPACK_MESSAGE_ROWID
( item OUT ROWID );
PROCEDURE DBMS_RANDOM.INITIALIZE
( seed IN BINARY_INTEGER );
FUNCTION DBMS_RANDOM.RANDOM
RETURN BINARY_INTEGER;
PROCEDURE DBMS_RANDOM.SEED
( seed IN BINARY_INTEGER );
PROCEDURE DBMS_RANDOM.TERMINATE;
FUNCTION DBMS_ROWID.ROWID_BLOCK_NUMBER
( row_id IN ROWID )
RETURN NUMBER;
FUNCTION DBMS_ROWID.ROWID_CREATE
( rowid_type IN NUMBER
,object_number IN NUMBER
,relative_fno IN NUMBER
,block_number IN NUMBER
,row_number IN NUMBER )
RETURN ROWID;
PROCEDURE DBMS_ROWID.ROWID_INFO
( rowid_in IN ROWID
,rowid_type OUT NUMBER
,object_number OUT NUMBER
,relative_fno OUT NUMBER
,block_number OUT NUMBER
,row_number OUT NUMBER );
FUNCTION DBMS_ROWID.ROWID_OBJECT
( row_id IN ROWID )
RETURN NUMBER;
FUNCTION DBMS_ROWID.ROWID_RELATIVE_FNO
( row_id IN ROWID )
RETURN NUMBER;
FUNCTION DBMS_ROWID.ROWID_ROW_NUMBER
( row_id IN ROWID )
( row_id IN ROWID )
FUNCTION DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO
( row_id IN ROWID
,schema_name IN VARCHAR2
,object_name IN VARCHAR2 )
RETURN NUMBER;
FUNCTION DBMS_ROWID.ROWID_TO_EXTENDED
( old_rowid IN ROWID
,schema_name IN VARCHAR2
,object_name IN VARCHAR2
,conversion_type IN INTEGER )
RETURN ROWID;
FUNCTION DBMS_ROWID.ROWID_TO_RESTRICTED
( old_rowid IN ROWID
,conversation_type IN INTEGER )
RETURN ROWID;
FUNCTION DBMS_ROWID.ROWID_TYPE
( row_id IN ROWID )
RETURN NUMBER;
FUNCTION DBMS_ROWID.ROWID_VERIFY
( rowid_in IN ROWID
,schema_name IN VARCHAR2
,object_name IN VARCHAR2
,conversion_type IN INTEGER )
RETURN NUMBER;
PROCEDURE DBMS_SESSION.CLOSE_DATABASE_LINK
( dblink IN VARCHAR2 );
PROCEDURE DBMS_SESSION.FREE_UNUSED_USER_MEMORY;
FUNCTION DBMS_SESSION.IS_ROLE_ENABLED
( rolename IN VARCHAR2)
RETURN BOOLEAN;
FUNCTION DBMS_SESSION.IS_SESSION_ALIVE
( uniqueid IN VARCHAR2 )
RETURN BOOLEAN;
PROCEDURE DBMS_SESSION.RESET_PACKAGE;
PROCEDURE DBMS_SESSION.SET_CLOSE_CHACHED_OPEN_CURSORS
( close_cursors IN BOOLEAN );
PROCEDURE DBMS_SESSION.SET_LABEL
( lbl IN VARCHAR2 );
PROCEDURE DBMS_SESSION.SET_MLS_LABEL_FORMAT
( fmt IN VARCHAR2 );
PROCEDURE DBMS_SESSION.SET_NLS
( parm IN VARCHAR2
,value IN VARCHAR2 );
PROCEDURE DBMS_SESSION.SET_ROLE
( role_cmd IN VARCHAR2 );
PROCEDURE DBMS_SESSION.SET_SQL_TRACE
( sql_trace IN BOOLEAN );
FUNCTION DBMS_SESSION.UNIQUE_SESSION_ID
RETURN VARCHAR2;
PROCEDURE DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD
( threshold_size IN NUMBER );
PROCEDURE DBMS_SHARED_POOL.KEEP
( name IN VARCHAR2
,flag IN CHAR DEFAULT ' P ' );
PROCEDURE DBMS_SHARED_POOL.SIZES
( minsize IN NUMBER );
PROCEDURE DBMS_SHARED_POOL.UNKEEP
( name IN VARCHAR2
,flag IN CHAR DEFAULT ' P ' );
PROCEDURE DBMS_SPACE.FREE_BLOCKS
( segment_owner IN VARCHAR2
,segment_name IN VARCHAR2
,segment_type IN VARCHAR2
,freelist_group_id IN NUMBER
,free_blks OUT NUMBER
,scan_limit IN NUMBER DEFAULT NULL
[ ,partition_name IN VARCHAR2 DEFAULT NULL ] );
PROCEDURE DBMS_SPACE.UNUSED_SPACE
( segment_owner IN VARCHAR2
,segment_name IN VARCHAR2
,segment_type IN VARCHAR2
,total_blocks OUT NUMBER
,total_bytes OUT NUMBER
,unused_blocks OUT NUMBER
,unused_bytes OUT NUMBER
,last_used_extent_file_id OUT NUMBER
,last_used_extent_block_id OUT NUMBER
,last_used_block OUT NUMBER
[ ,partition_name IN VARCHAR2 DEFAULT NULL ] );
(c IN INTEGER
,name IN VARCHAR2
,<table_variable IN datatype>
[, index1 IN INTEGER
, index2 IN INTEGER ] );
n_tab IN DBMS_SQL.NUMBER_TABLE
c_tab IN DBMS_SQL.VARCHAR2_TABLE
d_tab IN DBMS_SQL.DATE_TABLE
bl_tab IN DBMS_SQL.BLOB_TABLE
cl_tab IN DBMS_SQL.CLOB_TABLE
bf_tab IN DBMS_SQL.BFILE_TABLE
(c IN INTEGER
,name IN VARCHAR2
,value IN NUMBER | VARCHAR2 | DATE | BLOB | CLOB CHARACTER SET ANY_CS | BFILE
[,out_value_size IN INTEGER ] );
PROCEDURE DBMS_SQL.BIND_VARIABLE_CHAR
( c IN INTEGER
,name IN VARCHAR2
,value IN CHAR CHARACTER SET ANY_CS
[,out_value_size IN INTEGER ] );
PROCEDURE DBMS_SQL.BIND_VARIABLE_RAW
( c IN INTEGER
,name IN VARCHAR2
,value IN RAW
[,out_value_size IN INTEGER ] );
PROCEDURE DBMS_SQL.BIND_VARIABLE_ROWID
( c IN INTEGER
,name IN VARCHAR2
,value IN ROWID );
PROCEDURE DBMS_SQL.CLOSE_CURSOR
( c IN OUT INTEGER );
PROCEDURE DBMS_SQL.COLUMN_VALUE
( c IN INTEGER
,position IN INTEGER
,value OUT NUMBER | VARCHAR | DATE | BLOB | CLOB CHARACTER SET ANY_CS | BFULE | MLSLABEL );
[,column_error OUT NUMBER
[,actual_length OUT INTEGER ]] );
PROCEDURE DBMS_SQL.COLUMN_VALUE
( c IN INTEGER
,position IN INTEGER
,<table_parameter IN table_type>);
n_tab IN DBMS_SQL.NUMBER_TABLE
c_tab IN DBMS_SQL.VARCHAR2:TABLE
d_tab IN DBMS_SQL.DATE_TABLE
bl_tab IN DBMS_SQL.BLOB_TABLE
cl_tab IN DBMS_SQL.CLOB_TABLE
bf_tab IN DBMS_SQL.BFILE_TABLE
PROCEDURE DBMS_SQL.COLUMN_VALUE_CHAR
( c IN INTEGER
,position IN INTEGER
,value OUT CHAR CHARACTER SET ANY_CS
[,column_error OUT NUMBER
[,actual_length OUT INTEGER ]] );
PROCEDURE DBMS_SQL.COLUMN_VALUE_LONG
( c IN INTEGER
,position IN INTEGER
,length IN INTEGER
,offset IN INTEGER
,value OUT VARCHAR2
,value_length OUT INTEGER );
PROCEDURE DBMS_SQL.COLUMN_VALUE_RAW
( c IN INTEGER
,position IN INTEGER
,value OUT RAW
[,column_error OUT NUMBER
[,actual_length OUT INTEGER ]] );
PROCEDURE DBMS_SQL.COLUMN_VALUE_ROWID
( c IN INTEGER
,position IN INTEGER
,value OUT ROWID );
[,column_error OUT NUMBER
[,actual_length OUT INTEGER]] );
PROCEDURE DBMS_SQL.DEFINE_ARRAY
( c IN INTEGER
,position IN INTEGER
,<table_parameter IN table_type>
,cnt IN INTEGER
,lower_bound IN INTEGER );
n_tab IN DBMS_SQL.NUMBER_TABLE
c_tab IN DBMS_SQL.VARCHAR2_TABLE
d_tab IN DBMS_SQL.DATE_TABLE
bl_tab IN DBMS_SQL.BLOB_TABLE
cl_tab IN DBMS_SQL.CLOB_TABLE
bf_tab IN DBMS_SQL.BFILE_TABLE
PROCEDURE DBMS_SQL.DEFINE_COLUMN
( c IN INTEGER
,position IN INTEGER
,column IN NUMBER | DATE | BLOB | CLOB CHARACTER SET ANY_CD | BFILE | MLSLABEL );
PROCEDURE DBMS_SQL.DEFINE_COLUMN
( c IN INTEGER
,position IN INTEGER
,column IN VARCHAR2 CHARACTER SET ANY_CS
,column_size IN INTEGER );
PROCEDURE DBMS_SQL.DEFINE_COLUMN_CHAR
( c IN INTEGER
,position IN INTEGER
,column size IN INTEGER);
PROCEDURE DBMS_SQL.DEFINE_COLUMN_LONG
( c IN INTEGER
,position IN INTEGER );
PROCEDURE DBMS_SQL.DEFINE_COLUMN_LONG
( c IN INTEGER
,position IN INTEGER );
PROCEDURE DBMS_SQL.DEFINE_COLUMN_RAW
( c IN INTEGER
,position IN INTEGER
,column IN RAW
,column_size IN INTEGER );
PROCEDURE DBMS_SQL.DEFINE_COLUMN_ROWID
( c IN INTEGER
,position IN INTEGER
,column IN ROWID );
FUNCTION DBMS_SQL.EXECUTE
( c IN INTEGER
RETURN INTEGER;
FUNCTION DBMS_SQL.EXECUTE_AND_FETCH
( c IN INTEGER
,exact IN BOOLEAN DEFAULT FALSE )
RETURN INTEGER;
FUNCTION DBMS_SQL.FETCH_ROWS
( c IN INTEGER
RETURN INTEGER;
FUNCTION DBMS_SQL.IS_OPEN
( c IN INTEGER )
RETURN BOOLEAN;
FUNCTION DBMS_SQL.LAST_ERROR_POSITION
RETURN INTEGER;
FUNCTION DBMS_SQL.LAST_ROW_COUNT
RETURN INTEGER;
FUNCTION DBMS_SQL.LAST_ROW_ID
RETURN ROWID;
FUNCTION DBMS_SQL.LAST_SQL_FUNCTION_CODE
RETURN INTEGER;
FUNCTION DBMS_SQL.OPEN_CURSOR
RETURN INTEGER;
PROCEDURE DBMS_SQL.PARSE
( c IN INTEGER
,statement IN VARCHAR2
,language_flag IN INTEGER );
PROCEDURE DBMS_SQL.PARSE
( c IN INTEGER
,statement IN VARCHAR25
,lb IN INTEGER
,ub IN INTEGER
,lfflg IN BOOLEAN
,language_flag IN INTEGER );
PROCEDURE DBMS_SQL.VARIABLE_VALUE
( c IN INTEGER
,name IN VARCHAR2
,value OUT NUMBER | VARCHAR2 | DATE | BLOB | CLOB CHARACTER SET ANY_CS | BFILE | MLSLABEL );
PROCEDURE DBMS_SQL.VARIABLE_VALUE
( c IN INTEGER
,name IN VARCHAR2
,value IN <table_type> );
DBMS_SQL.NUMBER_TABLE
DBMS_SQL.VARCHAR2_TABLE
DBMS_SQL.DATE_TABLE
DBMS_SQL.BLOB_TABLE
DBMS_SQL.CLOB_TABLE
DBMS_SQL.BFILE_TABLE
PROCEDURE DBMS_SQL.VARIABLE_VALUE_CHAR
( c IN INTEGER
,name IN VARCHAR2
,value OUT CHAR CHARACTER SET ANY_CS );
PROCEDURE DBMS_SQL.VARIABLE_VALUE_RAW
( c IN INTEGER
,name IN VARCHAR2
,value OUT RAW );
PROCEDURE DBMS_SQL.VARIABLE_VALUE_ROWID
( c IN INTEGER
,name IN VARCHAR2
,value OUT ROWID );
PROCEDURE DBMS_STANDARD.RAISE_APPLICATION_ERROR
( num BINARY_INTEGER
,msg VARCHAR2
,keeperrorstack boolean default FALSE );
FUNCTION INSERTING RETURN boolean;
FUNCTION DELETING RETURN boolean;
FUNCTION UPDATING RETURN boolean;
FUNCTION UPDATING ( colnam VARCHAR2 ) RETURN boolean;
PROCEDURE COMMIT;
PROCEDURE COMMIT_CM ( vc VARCHAR2 );
PROCEDURE ROLLBACK_NR:
PROCEDURE ROLLBACK_SV ( save_point VARCHAR2 );
PROCEDURE SAVEPOINT ( save_point VARCHAR2 );
PROCEDURE SET_TRANSACTION_USE ( vc VARCHAR2 );
PROCEDURE DBMS_SYSTEM.READ_EV
( iev BINARY_INTEGER
,oev OUT BINARY_INTEGER );
PROCEDURE DBMS_SYSTEM.SET_EV
( si BINARY_INTEGER
,se BINARY_INTEGER
,ev BINARY_INTEGER
,le BINARY_INTEGER
,nm IN VARCHAR2 );
PROCEDURE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION
( sid IN NUMBER
,serial # IN NUMBER
,sql_trace IN BOOLEAN );
PROCEDURE DBMS_TRANSACTION.ADVISE_COMMIT;
PROCEDURE DBMS_TRANSACTION.ADVISE_NOTHING;
PROCEDURE DBMS_TRANSACTION.ADVISE_ROLLBACK;
PROCEDURE DBMS_TRANSACTION.BEGIN_DESCRETE_TRANSACTION;
PROCEDURE DBMS_TRANSACTION.COMMIT;
PROCEDURE DBMS_TRANSACTION.COMMIT_COMMENT
( cmnt IN VARCHAR2 );
PROCEDURE DBMS_TRANSACTION.COMMIT_FORCE
( xid IN VARCHAR2
[,scn IN VARCHAR2 DEFAULT NULL ) ];
FUNCTION DBMS_TRANSACTION.LOCAL_TRANSACTION_ID
( create_transaction IN BOOLEAN := FALSE )
RETURN VARCHAR2;
PROCEDURE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY
( xid IN VARCHAR2 );
PROCEDURE DBMS_TRANSACTION.PURGE_MIXED
( xid IN VARCHAR2 );
PROCEDURE DBMS_TRANSACTION.READ_ONLY;
PROCEDURE DBMS_TRANSACTION.READ_WRITE;
PROCEDURE DBMS_TRANSACTION.ROLLBACK;
PROCEDURE DBMS_TRANSACTION.ROLLBACK_FORCE
( xid IN VARCHAR2 );
PRODECURE DBMS_TRANSACTION.ROLLBACK_SAVEPOINT
( savept IN VARCHAR2 );
PROCEDURE DBMS_TRANSACTION.SAVEPOINT
( savept IN VARCHAR2 );
FUNCTION DBMS_TRANSACTION.STEP_ID
RETURN NUMBER;
PROCEDURE DBMS_TRANSACTION.USE_ROLLBACK_SEGMENT
( rb_name IN VARCHAR2 );
PROCEDURE DBMS_UTILITY.ANALYZE_DATABASE
( method IN VARCHAR2
,estimate_rows IN NUMBER DEFAULT NULL
,estimate_percent IN NUMBER DEFAULT NULL
,method_opt IN VARCHAR2 DEFAULT NULL );
PROCEDURE DBMS_UTILITY.ANALYZE_PART_OBJECT
( schema IN VARCHAR2 DEFAULT NULL
,object_name IN VARCHAR2 DEFAULT NULL
,object_type IN CHAR DEFAULT ' T '
,command_type IN CHAR DEFAULT ' E '
,command_opt IN VARCHAR2 DEFAULT NULL
,sample_clause IN VARCHAR2
DEFAULT 'SAMPLE 5 PERCENT ' );
PROCEDURE DBMS_UTILITY.ANALYZE_SCHEMA
( schema IN VARCHAR2
,method IN VARCHAR2
,estimate_rows IN NUMBER DEFAULT NULL
,estimate_percent IN NUMBER DEFAULT NULL
,method_opt IN VARCHAR2 DEFAULT NULL );
PROCEDURE DBMS_UTILITY.COMMA_TO_TABLE
( list IN VARCHAR2
,tablen OUT BINARY_INTEGER
,tab OUT UNCL_ARRAY );
PROCEDURE DBMS_UTILITY.COMPILE_SCHEMA
( schema IN VARCHAR2) ;
FUNCTION DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK
( dba IN NUMBER )
RETURN NUMBER;
FUNCTION DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE
( dba IN NUMBER )
RETURN NUMBER;
PROCEDURE DBMS_UTILITY.DB_VERSION
( version OUT VARCHAR2
,compatibility OUT VARCHAR2 );
PROCEDURE DBMS_UTILITY.EXEC_DDL_STATEMENT
( parse_string IN VARCHAR2 );
FUNCTION DBMS_UTILITY.FORMAT_CALL_STACK
RETURN VARCHAR2;
FUNCTION DBMS_UTILITY.FORMAT_ERROR_STACK
RETURN VARCHAR2;
FUNCTION DBMS_UTILITY.GET_HASH_VALUE
( name IN VARCHAR2
,base IN NUMBER
,hash_size IN NUMBER )
RETURN NUMBER;
FUNCTION DBMS_UTILITY.GET_PARAMETER_VALUE
( parnam IN VARCHAR2
,intval IN OUT BINARY_INTEGER
,strval IN OUT VARCHAR2 )
RETURN BINARY INTEGER;
FUNCTION DBMS_UTILITY.GET_TIME
RETURN NUMBER;
FUNCTION DBMS_UTILITY.IS_PARALLEL_SERVER
RETURN BOOLEAN;
FUNCTION DBMS_UTILITY.MAKE_DATA_BLOCK_ADDRESS
( file IN NUMBER
,block IN NUMBER )
RETURN NUMBER;
PROCEDURE DBMS_UTILITY.NAME_RESOLVE
( name IN VARCHAR2
,context IN NUMBER
,schema OUT VARCHAR2
,part1 OUT VARCHAR2
,part2 OUT VARCHAR2
,dblink OUT VARCHAR2
,part1_type OUT NUMBER
,object_number OUT NUMBER );
PROCEDURE DBMS_UTILITY.NAME_TOKENIZE
( name IN VARCHAR2
,a OUT VARCHAR2
,b OUT VARCHAR2
,c OUT VARCHAR2
,dblink OUT VARCHAR2
,nextpos OUT BINARY_INTEGER );
FUNCTION DBMS_UTILITY.PORT_STRING
RETURN VARCHAR2;
PROCEDURE DBMS_UTILITY.TABLE_TO_COMMA
( tab IN UNCL_ARRAY
,tablen OUT BINARY_INTEGER
,list OUT VARCHAR2 );
PROCEDURE UTL_FILE.FCLOSE
( file IN OUT FILE_TYPE );
PROCEDURE UTL_FILE.CLOSE_ALL;
PROCEDURE UTL_FILE.FFLUSH
( file IN FILE_TYPE );
FUNCTION UTL_FILE.FOPEN
( location IN VARCHAR2
,filename IN VARCHAR2
,open_mode IN VARCHAR2 )
RETURN FILE_TYPE:
PROCEDURE UTL_FILE.GET_LINE
( file IN FILE_TYPE
,buffer_OUT VARCHAR2 );
FUNCTION UTL_FILE.IS_OPEN
( file IN FILE_TYPE )
RETURN BOOLEAN;
PROCEDURE UTL_FILE.NEW_LINE
( file IN FILE_TYPE
,lines IN NATURAL := 1 );
PROCEDURE UTL_FILE.PUT
( file IN FILE_TYPE
,buffer IN VARCHAR2 );
PROCEDURE UTL_FILE.PUT_LINE
( file IN FILE_TYPE
,buffer IN VARCHAR2 );
PROCEDURE UTL_FILE.PUTF
( file IN FILE_TYPE
,format IN VARCHAR2
,arg1 IN VARCHAR2 DEFAULT NULL
,arg2 IN VARCHAR2 DEFAULT NULL
,arg3 IN VARCHAR2 DEFAULT NULL
,arg4 IN VARCHAR2 DEFAULT NULL
,arg5 IN VARCHAR2 DEFAULT NULL );
FUNCTION UTL_RAW.BIT_AND
( r1 IN RAW
,r2 IN RAW )
RETURN RAW;
FUNCTION UTL_RAW.BIT_COMPLEMENT
( r1 IN RAW
,r2 IN RAW
RETURN RAW;
FUNCTION UTL_RAW.BIT_OR
( r1 IN RAW
,r2 IN RAW )
RETURN RAW;
FUNCTION UTL_RAW.BIT_XOR
( r1 IN RAW
,r2 IN RAW )
RETURN RAW;
FUNCTION UTL_RAW.CAST_TO_RAW
( c IN VARCHAR2 )
RETURN RAW;
FUNCTION UTL_RAW.CAST_TO_VARCHAR2
( r IN RAW )
RETURN VARCHAR2;
FUNCTION UTL_RAW.COMPARE
( r1 IN RAW
,r2 IN RAW
,pad IN RAW DEFAULT NULL )
RETURN NUMBER;
FUNCTION UTL_RAW.CONTACT
( r1 IN RAW DEFAULT NULL
,r2 IN RAW DEFAULT NULL
,r3 IN RAW DEFAULT NULL
,r4 IN RAW DEFAULT NULL
,r5 IN RAW DEFAULT NULL
,r6 IN RAW DEFAULT NULL
,r7 IN RAW DEFAULT NULL
,r8 IN RAW DEFAULT NULL
r9 IN RAW DEFAULT NULL
r10 IN RAW DEFAULT NULL
r11 IN RAW DEFAULT NULL
r12 IN RAW DEFAULT NULL
RETURN RAW:
FUNCTION UTL_RAW.CONVERT
( r IN RAW
,to_charset IN VARCHAR2
,from_charset IN VARCHAR2 )
RETURN RAW;
FUNCTION UTL_RAW.COPIES
( r IN RAW
,n IN NUMBER )
RETURN RAW;
FUNCTION UTL_RAW.LENGTH
( r IN RAW )
RETURN NUMBER;
FUNCTION UTL_RAW.OVERLAY
( overlay_str IN RAW
,target IN RAW
,pos IN BINARY_INTEGER DEFAULT 1
,len IN BINARY_INTEGER DEFAULT NULL
,pad IN RAW DEFAULT NULL )
RETURN RAW;
FUNCTION UTL_RAW.REVERSE
( r IN RAW )
RETURN RAW;
FUNCTION UTL_RAW.SUBSTAR
( r IN RAW
,pos IN BINARY_INTEGER
,len IN BINARY_INTEGER DEFAULT NULL )
RETURN RAW;
FUNCTION UTL_RAW.TRANSLATE
( r IN RAW
,from_set IN RAW
,to_set IN RAW )
RETURN RAW;
FUNCTION UTL_RAW.TRANSLITERATE
( r IN RAW
,to_set IN RAW DEFAULT NULL
,from_set IN RAW DEFAULT NULL
,pad IN RAW DEFAULT NULL )
RETURN RAW;
FUNCTION UTL_RAW.XRANGE
( start_byte IN RAW DEFAULT NULL
,end_byte IN RAW DEFAULT NULL )
RETURN RAW;
PROCEDURE UTL_REF.DELETE_OBJECT
( reference IN REF ANY );
PROCEDURE UTL_REF.LOCK_OBJECT
( reference IN REF ANY );
PROCEDURE UTL_REF.LOOK_OBJECT
( reference IN REF ANY
,object IN OUT ANY );
PROCEDURE UTL_REF.SELECT_OBJECT
( reference IN REF ANY
,object IN OUT ANY );
PROCEDURE UTL_REF.UPDATE_OBJECT
( reference IN REF ANY
,object IN OUT ANY );