Oracle PSTDY_DATAPUMP_SUPPORT
Version 23c

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 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
Source {ORACLE_HOME}/rdbms/admin/prvtpstdy.plb
Subprograms
 
INSTANCE_CALLOUT_IMP
Undocumented

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
 
INSTANCE_EXPORT_ACTION
Undocumented

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);
DECLARE
 lAction  VARCHAR2(128);
 lAltName VARCHAR2(128);
 lWhereCl VARCHAR2(128);
BEGIN
  pstdy_datapump_support.instance_export_action('TEST', 'C##UWCLASS', 2, '21.1.0', lAction, lAltName, lWhereCl);
  dbms_output.put_line(lAction);
  dbms_output.put_line(lAltName);
  dbms_output.put_line(lWhereCl);
END;
/

PL/SQL procedure successfully completed.

Related Topics
AMGT$DATAPUMP
Built-in Functions
Built-in Packages
DataPump Executable
DBMS_DATAPUMP_INT
DBMS_DATAPUMP_UTL
Export
Import
KUPD$DATA_INT
OLS$DATAPUMP
SQLFW$DATAPUMP
TSDP$DATAPUMP
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx