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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_DEBUG
DBMS_PIPE
PBREAK
PBRPH
PBSDE
What's New In 19c
What's New In 20c-21c

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