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
Internal DataPump support package for Data Guard Physical Standbys
AUTHID
DEFINER
Dependencies
DBMS_DATAPUMP
KU$_JOBDESC
KU$_STATUS
Documented
No
First Available
12.1
Security Model
Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE role
Demo fails because it was not run from within an executing DataPump job.
Identical name and parameters were found in TSDP$DATAPUMP
pstdy_datapump_support.instance_callout_imp(
obj_name IN VARCHAR2,
obj_schema IN VARCHAR2,
obj_type IN NUMBER,
prepost IN BINARY_INTEGER,
action OUT VARCHAR2,
alt_name OUT VARCHAR2);
CREATE TABLE c##uwclass.test AS
SELECT * FROM tab$;
Table created.
SELECT type#
FROM obj$
WHERE name = 'TEST';
TYPE#
------
2
DECLARE
lAction VARCHAR2(120);
lAltName VARCHAR2(120);
BEGIN
pstdy_datapump_support.instance_callout_imp('TEST', 'C##UWCLASS', 2, 0, lAction, lAltName);
dbms_output.put_line(lAction);
dbms_output.put_line(lAltName);
END;
/
DECLARE
*
ERROR at line 1:
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4494
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5973
ORA-06512: at "SYS.PSTDY_DATAPUMP_SUPPORT", line 42
ORA-06512: at line 5
Demo code doesn't fail but neither is there an output
pstdy_datapump_support.instance_export_action(
obj_name IN VARCHAR2,
obj_schema IN VARCHAR2,
obj_type IN NUMBER,
tgt_version IN VARCHAR2,
action OUT VARCHAR2,
alt_name OUT VARCHAR2,
where_clause OUT VARCHAR2);