Oracle | PBSDE

Oracle PBSDE Version 21c

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 DBMS_DEBUG and PROBE Support

AUTHID CURRENT_USER

Dependencies

DBMS_DEBUG	DBMS_STANDARD	PBUTL
DBMS_DEBUG_VC2COLL	PBREAK	PLITBLM
DBMS_SESSION

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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

Subprograms

Undocumented pbsde.debug_loop RETURN BINARY_INTEGER;

SELECT 
      pbsde.debug_loop

      FROM dual;

      

      -- hangs for at least 5 minutes, perhaps forever

INIT

Undocumented pbsde.init( debugid IN VARCHAR2, create_pipes IN BOOLEAN, debug_role IN VARCHAR2, debug_role_pwd IN VARCHAR2);

exec pbsde.init('ZZYZX', FALSE, NULL, NULL);

SHUTDOWN

Undocumented pbsde.shutdown;

-- this procedure has not parameters

      

      SQL> exec pbsde.shutdown;

      BEGIN pbsde.shutdown; END;

      *

      ERROR at line 1:

      ORA-23321: Pipename may not be null

      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86

      ORA-06512: at "SYS.DBMS_PIPE", line 128

      ORA-06512: at "SYS.PBREAK", line 259

      ORA-06512: at "SYS.PBSDE", line 107

      ORA-06512: at line 1