Minimum requirements to use the Debugger (7704)

SQL Navigator
Minimum requirements to use the Debugger.

Debugger Minimum Requirements:

1. Oracle version 7.3.4.1 with at least Oracle Probe API 2.0

To get your Oracle Probe API version run:

DECLARE
PROBE_MAJOR_VER VARCHAR2(10);
PROBE_MINOR_VER VARCHAR2(10);
BEGIN
DBMS_DEBUG.PROBE_VERSION(PROBE_MAJOR_VER, PROBE_MINOR_VER);
DBMS_OUTPUT.PUT_LINE('MAJOR='||PROBE_MAJOR_VER);
DBMS_OUTPUT.PUT_LINE('MINOR='||PROBE_MINOR_VER);
END;

2. Oracle Permission:
A. GRANT ALTER SESSION TO user_name;
B. GRANT CREATE SESSION TO user_name;
C. GRANT EXECUTE ON SYS.DBMS_DEBUG TO PUBLIC;

Optional for debugging procedures other then your own:

D. GRANT ALTER ANY PROCEDURE TO user_name; (compile)
E. GRANT CREATE ANY PROCEDURE TO user_name; (edit/save)