When to publish version 9.1

[Claus Pedersen]

At the bottom of the page PL/SQL Developer 9.0 - New Features it says:

PL/SQL Beautifier enhancements have been postponed to version 9.1 later this year.

This was in May 2011.

Do you have any plans for release of version 9.1?

 

[Marco Kalter]

We'll have a 10.0 beta release in the next weeks.

 

[Claus Pedersen]

OK, sounds good. Looking forward to hear more ...

 

[T-Gergely]

And will that handle xmltype (and tables containing xmltype) properly, finally? :S

 

[Marco Kalter]

Yes, it includes a fix for XMLTYPE instance queries.

 

[T-Gergely]

Thanks. In that case, I'd like to alpha-beta-whatever test it ASAP.

 

[Starina]

Please, tell us, what new features will we see?

 

[Marco Kalter]

We'll publish a "new features" page shortly.

 

[CTUDEHT]

Could You, please, provide an approximate date for the Developer 10.0 beta release?

Few weeks are already passed, I hope.
With best regards!

 

[Claus Pedersen]

Will it be possible to view the content of PL/SQL INDEX BY arrays in version 10 when debugging? Viewing the content of an array (used in for instance bulk collect) only shows

my_array = (Collection)

and using variable watch with "my_array.count" shows (Collection) and "my_array(1)" shows (Not a variable) if the array consists of a record type (like when using bulk collect).

The only way to find the number of indexes in an array is to write:
my_array(1).my_field
my_array(2).my_field
my_array(3).my_field
etc. until the watch shows (Not a variable)

And this is only possible if the array is dense (with indexes like 1,2,3) and not sparse (with indexes like 'Peter','Paul','Mary')

In Oracle SQL Developer, exploring content of arrays while debugging is fully possible, so it can be done.

Will this be improved in version 10?

 

[yeifang]

When to publish version 10 beta?

 

[Marco Kalter]

It should be available in 2 weeks.

 

[vlevi]

"It should be available in 2 weeks."
Great News!

 

[Bernhard S]

The announced 2 weeks were over last Friday, Nov 18.
How much longer do we have to wait?
Could you reveal any main changes that will be included?

 

[T-Gergely]

Yep, I've been waiting for xmltype related tables to work for ages. I'd like to test it ASAP.

 

[RobertG]

Marco,

When will the new version be available ?

Thanks

 

[Marco Kalter]

The beta should be available by the end of this month.

 

[vlevi]

"The beta should be available by the end of this month."
What month?

 

[T-Gergely]

Yeah, it should have been. I'd be okay with an alpha, though.

 

[Marco Kalter]

The beta will be available this week.

 

[T-Gergely]

Hell no, it still crashes and displays when selecting XMLTYPEs. I'd debugged the previous version and showed you where exactly it crashes in the exe. WHAT ELSE CAN I DO TO HELP YOU FIX THIS BUG IMMEDIATELY THAT'S IN PSD FOR YEARS?

 

[Marco Kalter]

The Oracle Client is buggy when it comes to XMLTYPE instances. We have worked around this in version 10.0.

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[T-Gergely]

No, you did NOT. I'm on pins and needles for months about this bug, and tested PSD version 10 as soon as I could (just like the earlier versions).
I've sent you Debug.txt along with EurekaLog.
Let me know if there's anything else I can help you with to fix this, please.

 

[T-Gergely]

Key F10 does not work for commit (even though F10 is displayed in the menu item), so I stop testing version 10 for now. But it's nowhere as important as XMLTYPE.