| General Information |
| Note: B |
| Source |
{ORACLE_HOME}/rdbms/admin/prvthrse.plb |
| First Available |
10gR1 |
| Data Types |
TYPE connect_info IS RECORD (
username VARCHAR2(30),
password VARCHAR2(30),
connect_identifier VARCHAR2(30),
connect_key VARCHAR2(??),
i_customer_id BINARY_INTEGER);
TYPE connect_info_set IS TABLE OF connect_info; |
| Dependencies |
| DBA_RECOVERABLE_SCRIPT |
DBMS_LOGREP_UTIL |
DBMS_STREAMS_MT |
| DBA__RECOVERABLE_SCRIPT_BLOCKS |
DBMS_RECO_SCRIPT_INT |
DBMS_STREAMS_SM |
| DBA__RECOVERABLE_SCRIPT_ERRORS |
DBMS_RECO_SCRIPT_INVOK |
DBMS_SYS_ERROR |
| DBA__RECOVERABLE_SCRIPT_HIST |
DBMS_RECO_SCRIPT_LIB |
DBMS_UTILITY |
| DBA__RECOVERABLE_SCRIPT_PARAMS |
DBMS_STREAMS_AUTO_INT |
PLITBLM |
| DBMS_ASSERT |
DBMS_STREAMS_MC |
|
|
| Security Model |
Owned by SYS with no granted privileges |
| Subprograms |
|
| |
| ADD_FORWARD_BLOCK |
| Undocumented |
dbms_recoverable_script.add_forward_block(
script_id IN RAW,
block IN CLOB,
dblink_forward IN VARCHAR2,
block_comment IN VARCHAR2,
block_num IN NUMBER); |
| TBD |
| |
| CREATE_SCRIPT |
| Creates a recoverable script |
dbms_recoverable_script.create_script(
invoking_pkg_owner IN VARCHAR2,
invoking_pkg IN VARCHAR2,
invoking_proc IN VARCHAR2,
script_comment IN VARCHAR2,
script_id OUT RAW); |
CREATE OR REPLACE PACKAGE testpkg AUTHID CURRENT_USER IS
PROCEDURE display_string(teststr IN VARCHAR2);
END testpkg;
/
CREATE OR REPLACE PACKAGE BODY testpkg IS
PROCEDURE display_string(teststr IN VARCHAR2) IS
BEGIN
dbms_output.put_line(teststr);
END;
END testpkg;
/
SELECT * FROM dba_recoverable_script;
SELECT * FROM dba_recoverable_script_blocks;
SELECT * FROM dba_recoverable_script_errors;
SELECT * FROM dba_recoverable_script_hist;
SELECT * FROM dba_recoverable_script_params;
set serveroutput on
DECLARE
r RAW(32);
BEGIN
dbms_recoverable_script.create_script('Test', 'A', 'B', 'C', r);
dbms_output.put_line(r);
END;
/
SELECT * FROM dba_recoverable_script;
SELECT * FROM dba_recoverable_script_blocks;
SELECT * FROM dba_recoverable_script_errors;
SELECT * FROM dba_recoverable_script_hist;
SELECT * FROM dba_recoverable_script_params;
-- replace the raw value with the one you receive
exec dbms_recoverable_script.drop_script(TO_RAW(TO_BLOB('CB68CBC3E4264A1680AE4620CFE6CD66')));
DECLARE
r RAW(32);
BEGIN
dbms_recoverable_script.create_script('Test1', 'DISPLAY_STRING', 'TESTPKG', 'SYS', r);
dbms_output.put_line(r);
dbms_recoverable_script.insert_param(r, 'TESTSTR', 'Morgan', 1);
dbms_recoverable_script.update_comment(r, 'Test2');
dbms_recoverable_script.run(r);
dbms_recoverable_script.drop_script(r);
END;
/
SELECT * FROM dba_recoverable_script;
SELECT * FROM dba_recoverable_script_blocks;
SELECT * FROM dba_recoverable_script_errors;
SELECT * FROM dba_recoverable_script_hist;
SELECT * FROM dba_recoverable_script_params; |
| |
| DROP_SCRIPT |
| Drops a recoverable script |
dbms_recoverable_script.drop_script(
script_id IN RAW,
flags IN BINARY_INTEGER,
ignore_remote_error IN BOOLEAN,
check_owner IN BOOLEAN,
force IN BOOLEAN); |
| See CREATE_SCRIPT Demo Above |
| |
| INSERT_PARAM |
| Undocumented |
dbms_recoverable_script.insert_param(
script_id IN RAW,
name IN VARCHAR2,
value IN VARCHAR2,
param_index IN NUMBER); |
| See CREATE_SCRIPT Demo Above |
| |
| MODIFY_FORWARD_BLOCK |
| Undocumented |
dbms_recoverable_script.modify_forward_block(
script_id IN RAW,
block_num IN VARCHAR2,
forward_block IN CLOB,
dblink_forward IN VARCHAR2,
action IN VARCHAR2); |
| TBD |
| |
| MODIFY_UNDO_BLOCK |
| Undocumented |
dbms_recoverable_script.modify_undo_block(
script_id IN RAW,
block_num IN NUMBER,
undo_block IN CLOB,
dblink_undo IN VARCHAR2,
action IN VARCHAR2); |
| TBD |
| |
| RUN |
Run a recovery script
Overload 1 |
dbms_recoverable_script.run(
script_id IN RAW,
forward IN BOOLEAN,
remote_state IN CLOB); |
| See CREATE_SCRIPT Demo Above |
| Overload 2 |
dbms_recoverable_script.run(
script_id IN RAW,
forward IN BOOLEAN,
remote_state IN CLOB,
flags IN BINARY_INTEGER,
conn_info IN dbms_recoverable_script.connect_info_set); |
| TBD |
| |
| UPDATE_COMMENT |
| Change a script comment |
dbms_recoverable_script.update_comment(
script_id IN RAW,
script_comment IN VARCHAR2); |
| See CREATE_SCRIPT Demo Above |
| |
| UPDATE_STATUS |
| Undocumented |
dbms_recoverable_script.update_status(
script_id IN RAW,
script_status IN NUMBER); |
| TBD |
