Oracle | DBMS_RECO_SCRIPT

Oracle DBMS_RECO_SCRIPT_INT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Streams Replication Recovery Internal Utilities

AUTHID DEFINER

Data Types DBLINK_TYPE SCRIPT_BLOCK_TYPE

Dependencies

DBMS_ASSERT	DBMS_STANDARD	RECO_SCRIPT$
DBMS_LOGREP_UTIL	DBMS_STREAMS_ADM_UTL	RECO_SCRIPT_BLOCK$
DBMS_RECOVERABLE_SCRIPT	DBMS_STREAMS_RPC	RECO_SCRIPT_ERROR$
DBMS_RECO_SCRIPT_INVOK	DBMS_SYS_ERROR	RECO_SCRIPT_PARAMS$

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthrse.plb
{ORACLE_HOME}/rdbms/admin/prvtbrse.plb

Subprograms

ADD_FORWARD_BLOCK	GET_UNDO_BLOCK	SYS_PURGE_LOCAL
CREATE_SCRIPT	GET_UNDO_BLOCKS	UPDATE_BLOCK_STATUS
GET_DBLINKS	INSERT_PARAM	UPDATE_COMMENT
GET_ERROR_BLOCK_NUM	MODIFY_FORWARD_BLOCK	UPDATE_DONE_BLOCK_NUM
GET_FORWARD_BLOCK	MODIFY_UNDO_BLOCK	UPDATE_STATUS
GET_FORWARD_BLOCKS	RECORD_ERROR	USER_PURGE
GET_SCRIPT_OWNER	SYS_PURGE

ADD_FORWARD_BLOCK

Undocumented dbms_reco_script_int.add_forward_block( script_id IN RAW, block IN CLOB, canon_dblink IN VARCHAR2, block_comment IN VARCHAR2, block_num OUT NUMBER);

TBD

CREATE_SCRIPT

Undocumented dbms_reco_script_int.create_script( invoking_pkg_owner IN VARCHAR2, invoking_pkg IN VARCHAR2, invoking_proc IN VARCHAR2, invoking_user IN VARCHAR2, script_comment IN VARCHAR2, script_id OUT RAW);

TBD

GET_DBLINKS

Undocumented dbms_reco_script_int.get_dblinks(script_id IN RAW) RETURN sys.dbms_reco_script_int.dblink_type;

TBD

GET_ERROR_BLOCK_NUM

Undocumented dbms_reco_script_int.get_error_block_num(script_id IN RAW) RETURN NUMBER;

TBD

GET_FORWARD_BLOCK

Undocumented dbms_reco_script_int.get_forward_block( script_id IN RAW, block_num IN NUMBER, forward_block OUT CLOB, canon_forward_dblink OUT VARCHAR2);

TBD

GET_FORWARD_BLOCKS

Undocumented dbms_reco_script_int.get_forward_blocks(script_id IN RAW) RETURN sys.dbms_reco_script_int.script_block_type;

TBD

GET_SCRIPT_OWNER

Undocumented dbms_reco_script_int.get_script_owner(script_id IN RAW) RETURN VARCHAR2;

TBD

GET_UNDO_BLOCK

Undocumented dbms_reco_script_int.get_undo_block( script_id IN RAW, block_num IN NUMBER, undo_block OUT CLOB, canon_undo_dblink OUT VARCHAR2);

TBD

GET_UNDO_BLOCKS

Undocumented dbms_reco_script_int.get_undo_blocks(script_id IN RAW) RETURN sys.dbms_reco_script_int.script_block_type;

TBD

INSERT_PARAM

Undocumented dbms_reco_script_int.insert_param( script_id IN RAW, p_name IN VARCHAR2, p_value IN VARCHAR2, p_ind IN NUMBER);

TBD

MODIFY_FORWARD_BLOCK

Undocumented dbms_reco_script_int.modify_forward_block( script_id IN RAW, block_num IN NUMBER, forward_block IN CLOB, canon_dblink IN VARCHAR2, action IN VARCHAR2);

TBD

MODIFY_UNDO_BLOCK

Undocumented dbms_reco_script_int.modify_undo_block( script_id IN RAW, block_num IN NUMBER, undo_block IN CLOB, canon_dblink IN VARCHAR2, action IN VARCHAR2);

TBD

RECORD_ERROR

Undocumented dbms_reco_script_int.record_error( script_id IN RAW, block_num IN NUMBER, error_num IN NUMBER, error_msg IN VARCHAR2);

TBD

SYS_PURGE

Undocumented dbms_reco_script_int.sys_purge(script_id IN RAW);

TBD

SYS_PURGE_LOCAL

Undocumented dbms_reco_script_int.sys_purge_local(script_id IN RAW);

TBD

UPDATE_BLOCK_STATUS

Undocumented dbms_reco_script_int.update_block_status( script_id IN RAW, block_num IN NUMBER, block_status IN NUMBER);

TBD

UPDATE_COMMENT

Update a script's comment dbms_reco_script_int.update_comment( script_id IN RAW, script_comment IN VARCHAR2);

TBD

UPDATE_DONE_BLOCK_NUM

Undocumented dbms_reco_script_int.update_done_block_num( script_id IN RAW, block_num IN NUMBER);

TBD

UPDATE_STATUS

Sets the status for a recovery script dbms_reco_script_int.update_status( script_id IN RAW, script_status IN NUMBER);

TBD

USER_PURGE

Undocumented dbms_reco_script_int.user_purge(script_id IN RAW);

TBD