Data that is queried within a procedure or package is not being displayed. Even though the options to print out arguments and Load info into grid from memory are set, nothing is being displayed.
RESOLUTION #1:
Make sure the Print OUT arguments/RETURN values to DBMS Output and Load into grid from memory (strong and weak) options are checked. These options can be found by clicking on the Output Options for Anonymous Block icon in the Set Parameters window.
RESOLUTION #2
Make sure DBMS Output window is enabled.
RESOLUTION #3
Make sure the user has the following permissions granted to them:
A. GRANT ALTER SESSION TO user_name;
B. GRANT CREATE SESSION TO user_name;
C. GRANT EXECUTE ON SYS.DBMS_DEBUG TO PUBLIC;
D. GRANT ALTER ANY PROCEDURE TO user_name; (compile)
E. GRANT CREATE ANY PROCEDURE TO user_name; (edit/save)
For Oracle 10G, the following additional grant is required:
F. GRANT DEBUG CONNECT SESSION TO user_name;
G. GRANT DEBUG ANY PROCEDURE TO user_name;
RESOLUTION #4
Make sure you areentering parameters for Stored Procedure without quotes (except Date parameter).
