Oracle | PBREAK

Oracle PBREAK 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 DEFINER

Dependencies

DBMS_DEBUG	PBRPH	PLITBLM
DBMS_DEBUG_VC2COLL	PBSDE	UTL_RAW
DBMS_PIPE	PBUTL

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

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

Subprograms

CLEAR_DEBUG	GET_NUMERIC_OPTION	READ_WORD
DEBUG_MESSAGE	GET_SCALAR	SET_BREAK_LINE
DELETE_BREAKPOINT	INTERNAL_VERSION_CHECK	SET_DEBUG
DISABLE_BREAKPOINT	IS_EXECUTABLE	SET_DEBUG_FLAGS
ENABLE_BREAKPOINT	PIPE_CUTTER	SET_NUMERIC_OPTION
GENERATE_TIDL	PRINT_BACKTRACE	SET_OER_BREAKPOINT
GET_CURRENT_EVENT	PRINT_BREAKPOINTS	SET_VALUE
GET_CURRENT_INFO	PRINT_FRAME_SOURCE	WRITE_PIPE
GET_DEBUG_FLAGS	PRINT_SOURCE	WRITE_REQUEST
GET_INDEXES	READ_INTO_TABLE	WRITE_TABLE
GET_LINE_MAP	READ_PIPE

CLEAR_DEBUG

Undocumented pbreak.clear_debug;

exec pbreak.clear_debug;

      BEGIN pbreak.clear_debug; END;

            *

      ERROR at line 1:

      ORA-06510: PL/SQL: unhandled user-defined exception

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

      ORA-06512: at line 1

DEBUG_MESSAGE

Undocumented pbreak.debug_message(buf IN VARCHAR2);

exec pbreak.debug_message('Test Message');

      

      PL/SQL procedure successfully completed.

DELETE_BREAKPOINT

Undocumented pbreak.delete_breakpoint( outpipe IN VARCHAR2, breakpoint IN BINARY_INTEGER, isoer IN BINARY_INTEGER);

TBD

DISABLE_BREAKPOINT

Undocumented pbreak.disable_breakpoint( outpipe IN VARCHAR2, breakpoint IN BINARY_INTEGER);

TBD

ENABLE_BREAKPOINT

Undocumented pbreak.enable_breakpoint( outpipe IN VARCHAR2, breakpoint IN BINARY_INTEGER);

TBD

GENERATE_TIDL

Undocumented pbreak.generate_tidl( msg IN OUT VARCHAR2, is_pak IN BINARY_INTEGER, inpipe IN VARCHAR2, outpipe IN VARCHAR2);

TBD

GET_CURRENT_EVENT

Undocumented pbreak.get_current_event RETURN BINARY_INTEGER;

SELECT 
      pbreak.get_current_event

      FROM dual;

      

      GET_CURRENT_EVENT

      -----------------

                      0

GET_CURRENT_INFO

Undocumented pbreak.get_current_info( run_info OUT sys.dbms_debug.runtime_info, info_requested IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

GET_DEBUG_FLAGS

Undocumented pbreak.get_debug_flags RETURN BINARY_INTEGER;

SELECT pbreak.get_debug_flags

      FROM dual;

      

      GET_DEBUG_FLAGS

      ---------------

GET_INDEXES

Undocumented pbreak.get_indexes( varname IN VARCHAR2, ith_handle IN BOOLEAN, handle IN sys.dbms_debug.program_info, frame# IN BINARY_INTEGER, entries OUT sys.dbms_debug.index_table) RETURN BINARY_INTEGER;

TBD

GET_LINE_MAP

Undocumented pbreak.get_line_map( program IN sys.dbms_debug.program_info, maxline OUT BINARY_INTEGER, number_of_entry_points OUT BINARY_INTEGER, linemap OUT RAW) RETURN BINARY_INTEGER;

TBD

GET_NUMERIC_OPTION

Undocumented pbreak.get_numeric_option(option_name IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

GET_SCALAR

Undocumented pbreak.get_scalar( varname IN VARCHAR2, with_handle IN BOOLEAN, handle IN sys.dbms_debug.program_info, frame# IN BINARY_INTEGER, value OUT VARCHAR2, format IN VARCHAR2) RETURN BINARY_INTEGER;

TBD

INTERNAL_VERSION_CHECK

Undocumented pbreak.internal_version_check;

exec pbreak.internal_version_check;

      

      PL/SQL procedure successfully completed.

IS_EXECUTABLE

Undocumented pbreak.is_executable( handle IN sys.dbms_debug.program_info, line# IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

PIPE_CUTTER

Undocumented pbreak.pipe_cutter( inpipe IN OUT VARCHAR2, outpipe IN OUT VARCHAR2, create_pipes IN BOOLEAN);

TBD

PRINT_BACKTRACE

Undocumented

Overload 1 pbreak.print_backtrace(listing OUT VARCHAR2);

TBD

Overload 2 pbreak.print_backtrace( request IN BINARY_INTEGER, msg IN VARCHAR2, backtrace IN sys.dbms_debug.vc2_table);

TBD

PRINT_BREAKPOINTS

Undocumented

Overload 1 pbreak.print_breakpoints(listing IN OUT VARCHAR2);

TBD

Overload 2 pbreak.print_breakpoints(breakpoints IN sys.dbms_debug.vc2_table);

TBD

PRINT_FRAME_SOURCE

Undocumented pbreak.print_frame_source( low IN BINARY_INTEGER, high IN BINARY_INTEGER, source IN OUT sys.dbms_debug.vc2_table, frame_num IN BINARY_INTEGER);

TBD

PRINT_SOURCE

Undocumented

Overload 1 pbreak.print_source( low IN BINARY_INTEGER, high IN BINARY_INTEGER, window IN BINARY_INTEGER, pflags IN BINARY_INTEGER, srctab IN OUT sys.dbms_debug_vc2coll, srctab_size IN OUT BINARY_INTEGER);

TBD

Overload 2 pbreak.print_source( low IN BINARY_INTEGER, high IN BINARY_INTEGER, source IN OUT sys.dbms_debug.vc2_table);

TBD

READ_INTO_TABLE

Undocumented pbreak.read_into_table( inpipe IN VARCHAR2, outpipe IN VARCHAR2, tab1 IN OUT sys.dbms_debug_vc2coll, tab2 IN OUT sys.dbms_debug.vc2_table, initial_message IN VARCHAR2, response IN BINARY_INTEGER, next_message IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

READ_PIPE

Undocumented pbreak.read_pipe( inpipe IN VARCHAR2, msg IN OUT VARCHAR2, msgtype IN BINARY_INTEGER);

TBD

READ_WORD

Undocumented pbreak.read_word( buf IN OUT VARCHAR2, word OUT VARCHAR2, noerror IN BOOLEAN);

TBD

SET_BREAK_LINE

Undocumented pbreak.set_break_line( program IN OUT sys.dbms_debug.program_info, breakpoint# OUT BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

SET_DEBUG

Undocumented pbreak.set_debug( debug_level IN BINARY_INTEGER, immediate IN BINARY_INTEGER);

exec pbreak.set_debug(0, 1);

      

      PL/SQL procedure successfully completed.

SET_DEBUG_FLAGS

Undocumented pbreak.set_debug_flags(request IN BINARY_INTEGER) RETURN BINARY_INTEGER;

TBD

SET_NUMERIC_OPTION

Undocumented pbreak.set_numeric_option( option_name IN VARCHAR2, option_value IN BINARY_INTEGER);

TBD

SET_OER_BREAKPOINT

Undocumented pbreak.set_oer_breakpoint( outpipe IN VARCHAR2, oer IN BINARY_INTEGER);

TBD

SET_VALUE

Undocumented pbreak.set_value( with_handle IN BOOLEAN, handle IN sys.dbms_debug.program_info, frame# IN BINARY_INTEGER, statement IN VARCHAR2) REtURN BINARY_INTEGER;

TBD

WRITE_PIPE

Undocumented pbreak.write_pipe( outpipe IN VARCHAR2, msg IN VARCHAR2, msgtype IN BINARY_INTEGER);

TBD

WRITE_REQUEST

Undocumented pbreak.write_request( inpipe IN VARCHAR2, outpipe IN VARCHAR2, request IN VARCHAR2, reply IN OUT VARCHAR2);

TBD

WRITE_TABLE

Undocumented pbreak.write_table( inpipe IN VARCHAR2, outpipe IN VARCHAR2, tab1 IN sys.dbms_debug_vc2coll, tab2 IN sys.dbms_debug.vc2_table, notifier IN BINARY_INTEGER, confirmation IN BINARY_INTEGER);

TBD