Print Thread
Debugger will not display nvarchar2 values
#50742 02/16/15 05:07 PM
Joined: Aug 2007
Posts: 13
R
Member
OP Offline
Member
R
Joined: Aug 2007
Posts: 13
If I try and debug any function, the debugger always says nvarchar2 values are null.
The sample test script below confirms this - just add v_var and v_nvar to the watch list. v_nvar will always show as null.

Tested using 10.0.5 and 11.0.0.1753 (beta) and get the same results.

declare
v_nvar nvarchar2(10);
v_var varchar2(10);
begin
select '123' into v_var from dual;
select '123' into v_nvar from dual;
select v_var into v_nvar from dual;
end;

Re: Debugger will not display nvarchar2 values
Richard Scott #50744 02/16/15 06:21 PM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
We'll check it out.


Marco Kalter
Allround Automations
Re: Debugger will not display nvarchar2 values
Marco Kalter #52154 09/21/15 03:56 PM
Joined: Aug 2007
Posts: 13
R
Member
OP Offline
Member
R
Joined: Aug 2007
Posts: 13
Were you able to investigate whether you can display nvarchar2 values please?

Re: Debugger will not display nvarchar2 values
Richard Scott #55983 02/24/17 09:50 AM
Joined: Aug 2007
Posts: 13
R
Member
OP Offline
Member
R
Joined: Aug 2007
Posts: 13
Any update on this please Marco?

Re: Debugger will not display nvarchar2 values
Richard Scott #55987 02/24/17 10:31 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
We do not yet have a fix for this.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.042s Queries: 15 (0.018s) Memory: 2.5142 MB (Peak: 3.0405 MB) Data Comp: Off Server Time: 2024-05-16 09:00:51 UTC
Valid HTML 5 and Valid CSS