Oracle DBMS_RECO_SCRIPT_INT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Streams Replication Recovery Internal Utilities
AUTHID DEFINER
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
Exceptions
Error Code Reason
   
   
   
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_RECOVERABLE_SCRIPT
DBMS_RECO_SCRIPT_INVOK
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx