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)
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy