BUG in Debug with NVARCHAR2 .. :))

[osvald]

create or replace procedure TT_DEB_NVCH (
    p_in_varch                   in VARCHAR2
   ,p_in_nvarch                  in NVARCHAR2
  )
  as
  begin
    dbms_output.put_line(p_in_varch);
    dbms_output.put_line(p_in_nvarch);
    -- ----
  end TT_DEB_NVCH;

begin
  tt_deb_nvch(p_in_varch => '1',
              p_in_nvarch => '2');
end;

i execute this procedure in debug mode (test window) after step: "step into" i put cursor point to input parameter "p_in_nvarch" (nvarchar2 data type), or add it to the "Watches" -- i found there the text "null"as a value of this param, although results of dbms_output shows the right value: '2'. I tested this code on versions 7.0.0.1050 (MBCS) & on 6.0.3

p.s.: this problem cocencernes to "local" variables of nvarchar2 data type in procedure.
----
p.p.s.: hope i described the problem well, if not -- sorry for my eng.

 

[Marco Kalter]

This seems to be an Oracle Debug API bug. The parameter value is reported as NULL.

 

[osvald]

ok, if it so, whether you are going to inform oracle support team about it?

 

[Pavlo]

Hello, I have the same problem and checked it with the SQL-Navigator of Oracle. Also in this program the nvarchar2 is shown as empty if it has a value.

 

[osvald]

yes as Marco wrote :it is an Oracle Debug API bug

I've tested it in PLSD, SQL-Navigator, TOAD

but Marco didn't answered: did he(or AllroundAutomations) informed ORACLE about that