Hi,

I just bought the new license for PL/SQL Developer 12.0 and while I tried to test the new funcionality on viewing User-Defined types variable values, it doesn't work for me.

My cleverbridge reference number: 110054213

My use case is the following:

1) I have a procedure which takes a super-type called BASE_OBJECT as a parameter

2) I call the procedure passing a well-defined type which "extends" the BASE_OBJECT, i.e., both BASE_OBJECT and "EXT_ExtendedObjectOfBaseObject_REC" types are defined as:

create type BASE_OBJECT as object ( rib_oid number,
member procedure appendNodeValues( i_prefix in varchar2)
) not final;
/

CREATE OR REPLACE TYPE "EXT_ExtendedObjectOfBaseObject_REC" UNDER BASE_OBJECT
....
// here goes several other types / attributes

3) In the program / procedure itself, I execute the following:

L_message := treat(I_MESSAGE AS "EXT_ExtendedObjectOfBaseObject_REC");

where:
L_message is the well-defined "EXT_ExtendedObjectOfBaseObject_REC";
and
I_MESSAGE is the generic BASE_OBJECT;

4) When I pass the mouse over L_message, it says "Not a variable".


This is really disappointing as I had v9.0 PL/SQL version and the only reason which I bought the new one was due to the Debugger Enhancements.

Can you take a look at this for me please? If this is not supported (and not planned to be), I kindly request a refund.

Thanks.

This is the same case that you already mailed to support on the 3rd? We're looking into this.

Yes it is. I didn't know the best channel for support so decided to put here, too.

Any ETA for the fix?

Hi Marco,

I'm trying to plan an enterprise-wide deployment of the new V12 of pl/sql developer, however would like to know when the debugging "bug" is slated to be fixed (which version, and the eta of when the version will be available). I am referring to the issue "h f" posted on 4/5/17. This is the feature the developers are most looking for but did not want to distribute until fixed.

All we are looking for is an estimated date so they can update their kanban stories accordingly. Thanks! --Kate Johnson

We're looking into this for version 12.0.3, which will be available in May.

Was this one supposed to be fixed in 12.0.3?
I just installed it and the behavior is the same. Debugger enhacements still not working for user-defined sub-types which extends super-types.

The test case above did not work because it is a mixed case object name and its name is longer than 30 characters. Both issues have been fixed in 12.0.3 and the test case seems to work just fine now.

Can you right-click on both types and select "Add debug information", to make sure that this is not the problem here?

Yes, both types are compiled with Debug option flag.
Above use case is ficticious but my use case uses Mixed Case Object Names, but they are created with double quotes (eg: "MyObjectName" so Oracle respects the CamelCase scenario.
I will send an email with evidences of my test case which shows that it still is not working as I expected.

Okay, we'll try to reproduce this with your test case when we receive it.