Enhancement Request

[Sebastien]

Hi,

I would like to suggest a few enhancements.

1) It would be nice if windows that do not respond anymore do not block PL/SQL developer and do not prevent you from closing them. Many times I had to close my PL/SQL developer for one window that did not work. I lost everything I was doing at that time. Same idea as if a program crashes you don't really want to have to restart Windows.

2) I saw a few enhancements done in 7.1 for the debugger. That's nice. But I noticed that when executing dynamic SQL, it goes back to the original anonymous block rather than showing the dynamic SQL.

3) The color coding provided in wList from softema for the window list was for sure very nice. As wList does not work anymore that would be nice to have the color coding as part of PL/SQL developer.

4) The autoComplete feature is not as powerful as the plugin it has replaced (textype).

5) In the test window, that would be nice to be able to see ROWTYPE records as you can see collection and/or having a function that adds the whole variable in the variable window. Support for XMLTYPE variables would be nice too.

Thanks for the good work!

Sebastien

 

[rbrooker]

2: wList has been updated to work with 7.1, download version 2.6.

 

[Marco Kalter]

1) It would be nice if windows that do not respond anymore do not block PL/SQL developer and do not prevent you from closing them. Many times I had to close my PL/SQL developer for one window that did not work. I lost everything I was doing at that time. Same idea as if a program crashes you don't really want to have to restart Windows.

In Dual Session Mode and Multi Session Mode, all database activities from a window are performed in a background thread, without blocking the application. Furthermore, the Recovery options from the Preferences should prevent most editing losses in case of a crash.

2) I saw a few enhancements done in 7.1 for the debugger. That's nice. But I noticed that when executing dynamic SQL, it goes back to the original anonymous block rather than showing the dynamic SQL.

You can only step though compiled PL/SQL.

4) The autoComplete feature is not as powerful as the plugin it has replaced (textype).

In 7.1.1 support is added for templates, so all template functionality is also available for AutoReplace. You can also assign a function key in 7.1.1.

5) In the test window, that would be nice to be able to see ROWTYPE records as you can see collection and/or having a function that adds the whole variable in the variable window. Support for XMLTYPE variables would be nice too.

This is on the list of enhancement requests.