The variable values are not displayed inside the sub-procedure. The selected variable for the watch displays undeclared identifier message.
It has been tested by setting a watch on variable name "wss_error_ind" and stepping into the code.
Here is sample sub-procedure:
CREATE OR REPLACE PROCEDURE <useraccount>.Test_Debugger (
wlp_i556_war_amt IN NUMBER,
wlp_o556_dollar_amt OUT VARCHAR2,
wlp_o556_return_cd OUT NUMBER,
wlp_o556_return_msg OUT VARCHAR2
)
AS
v_floor VARCHAR2 (100);
number_towords VARCHAR2 (2000);
wsh_text_amt VARCHAR2 (4000);
wss_error_ind VARCHAR2 (1);
wsh_error_msg VARCHAR2 (200);
wsh_pgm_name VARCHAR2 (06) DEFAULT 'AJI556';
wsh_paragraph_name VARCHAR2 (40) DEFAULT ' ';
wsh_sql_id VARCHAR2 (06) DEFAULT ' ';
wsh_sql_code NUMBER (05) DEFAULT 0;
wsh_sql_message VARCHAR2 (100) DEFAULT ' ';
PROCEDURE p_90000_proc_end_process
AS
BEGIN
IF wss_error_ind = 0
THEN
wlp_o556_dollar_amt := wsh_text_amt;
wsh_sql_code := 0;
wlp_o556_return_cd := 0;
wlp_o556_return_msg := 'SUCCESSFULL EXECUTION OF AJI556';
ELSE
wlp_o556_return_msg := wsh_error_msg;
wlp_o556_return_cd := wss_error_ind;
wlp_o556_dollar_amt := wsh_text_amt;
END IF;
END p_90000_proc_end_process;
PROCEDURE p_11000_check_input
AS
BEGIN
wsh_paragraph_name := 'P_11000_CHECK_INPUT';
IF wlp_i556_war_amt <= 0 or wlp_i556_war_amt IS NULL
THEN
wss_error_ind := 7;
wsh_error_msg := 'INVALID INPUT PARAMETERS';
p_90000_proc_end_process;
END IF;
END p_11000_check_input;
PROCEDURE p_10000_initialization
AS
BEGIN
wsh_paragraph_name := 'P_10000_INITIALIZATION';
wlp_o556_dollar_amt := 0;
wss_error_ind := 0;
wlp_o556_return_cd := 0;
wlp_o556_return_ms
The variable is declared outside the sub-procedure.
WORKAROUND
None
STATUS
Issue fixed in version TOAD for Oracle 9.6.1. The latest version of TOAD for Oracle can be downloaded at:
https://support.quest.com/SUPPORT/index?page=downloads
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy