During a debugging process, values with datatype nchar and nvarchar2 are not display in the watches window or when placing the mouse cursor over the value. The values shows as ".
Steps to Replicate:
1. create the example procedure
CREATE OR REPLACE
PROCEDURE nchartest
(MY_PARAM NCHAR)
AS
BEGIN
DECLARE
xxx NCHAR (20);
yyy NVARCHAR2 (100);
zzz VARCHAR2 (300);
BEGIN
-- If you try to view the contents of the parameter it is also ''.
-- when I set over the next to lines and view the contents of variables
-- xxx and yyy they are ''
xxx := 'testing xxx';
yyy := 'testing yyy';
zzz := xxx || yyy;
DBMS_OUTPUT.put_line(xxx);
DBMS_OUTPUT.put_line(yyy);
END;
END;
/
2. Start the debugging process by going to Debug | Step Into
3. Put in the value 'Testing Parameter' at the Parameters window
4. Click on the green play button to continue the debug process
5. Go to Debug | Step Into or hit F7 and step through the code
6. You can place your mouse over the xxx, yyy, zzz values once you step through it to see that xxx and yyy does not give any values
OR
You can put a watch on the variable to also notice that no values are shown.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of SQL Navigator.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center