Oracle | DBMS_SUM_RWEQ_EXPORT

Oracle DBMS_SUM_RWEQ_EXPORT_INTERNAL 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 Undocumented

AUTHID DEFINER

Dependencies

DBMS_LOB	DBMS_SYSTEM	SUM$
DBMS_STANDARD	OBJ$	USER$
DBMS_SUM_RWEQ_EXPORT

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtxrmv.plb

I_CREATE_EXP

Undocumented

No doubt my choice to create an object and then reference it wasn't correct but it did prove my concept valid dbms_sum_rweq_export_internal.i_create_exp( objid IN NUMBER, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

CREATE TABLE zzyzx AS 

      SELECT * FROM dual;

      

      Table created.

      

      SELECT object_id

      FROM dba_objects

      WHERE object_name = 'ZZYZX';

      

      OBJECT_ID

      ----------

          104982

      

      DECLARE

       outVal BINARY_INTEGER;

       retVal VARCHAR2(128);

      BEGIN

        retVal := dbms_sum_rweq_export_internal.i_create_exp(104982, outVal);

        dbms_output.put_line(outVal);

        dbms_output.put_line(retVal);

      END;

      /

      

      PL/SQL procedure successfully completed.