Oracle | PBREAK

Oracle PBREAK Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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