Sorting a package deletes all comments

[Frank Schmitt]

Hi,

I just detected a IMHO serious bug in PL/SQL-Developer (Version 7.1.1.1350).

Reproduce

• create a new package
• delete everything but the comments from the package header created by PL/SQL Developer template
• push the sort button

This will delete all comments in the package header

Versions affected
Build 1350; Build 1339 apparently works ok.

Workaround
Go back to build 1339, or don't use the sort feature

Kind regards
Frank

 

[Worker]

There's a sort button? I can find Edit->Selection->Sort in the menu, but no available toolbar button.

I can't reproduce this using the menu (although my package template is non-default).

 

[Marco Kalter]

It's the sort button of the Code Contents pane in the Program Window. We have fixed the bug, and I will upload it shortly.

 

[Worker]

Hey, that could be a useful little button. I love learning about features that have been staring me in the face all these years

 

[JEK]

That damn bug made me spent lot of time trying to recover the "lost" comments =(

Can't wait to download this bugfix.

 

[Marco Kalter]

Can't wait to download this bugfix.

You can download a preliminary fix here .

 

[JEK]

Thanks, Marco.

Can you describe this new patch like you did here ? I would never notice the "Variable horizontal scrollbar" option without that post...

 

[Marco Kalter]

Version 7.1.1.1360 includes the following fixes since the current 7.1.1.1339:

• Describing a program unit on an Oracle7 client or server would give incorrect parameter names
• Switching to the log tab page after a Table Import could lead to hang-up
• Command Window could give wrong highlighted text for errors
• Data Generator, Sequence Within Parent option did not work
• AutoReplace templates inserted the character before the text
• Inserting Templates would add a line break
• Import Tables: clicking on the From/To User combobox would cause "Invalid class typecast" error
• Selection Uncomment did not always work
• Views did not handle Unicode characters correct
• Large data editor did not handle Ctrl-Insert as copy
• Large data editor had an issue with trailing blank lines
• Escape did not always close large data editor (depended on tab-page)
• Save As did not work when a window was renamed
• Preferences could have the "changed" flag set when nothing was changed
• fixed logon history could have spaces in front of logon
• Project open/re-open/new did not work correct when a project was already open
• Project Re-open dropdown could display trimmed data
• Command Window AutoReplace could stop working after a "compile"
• Import Tables tool did not import Unicode CLOB's correctly in PL/SQL Developer format
• Find (& Replace) did not work correct with collapsed code
• "Variable horizontal scrollbar" preference added
• Window List redraw improved (flickering while compiling and speed)
• Large Data Editor: External Editor did not always convert text correct
• Splash screen hides after 30 secs inactivity to prevent waiting for hidden dialogs
• Program type or name was not always correctly determined in the Program Window, when preceded by a large amount of comment
• ---- New since 7.1.1.1350 ----
• Text Importer would not handle string fields correctly when using a SQL function
• Drag & Drop DDL into an editor would give incorrect capitalization when Keyword Case preference is set to Uppercase
• Import Tables: removed 80KB limitation for the import buffer size
• Browser folder Users > Objects did not have a Materialized views subfolder
• Compare User Objects Show differences button would fail when using EZConnect database names
• Disabled wList Plug-In
• Querying and editing Long columns with UTF8 data did not work correctly
• Edit > Selection > Uppercase/Lowercase/etc would not enable undo button
• Template would not set cursor [#] at end
• Modify Breakpoints popup was not available in Test Window
• Cursor fields could not be queried on Oracle 9.2 and later
• User-defined browser folder queries did not follow the "Use DBA Views if available" preference
• PL/SQL parser could not handle FUNCTION or PROCEDURE as a column or variable name
• Program Window could not handle REM or PROMPT commands with certain PL/SQL keywords at the start of a file
• NCHAR character set UTF8 could lead to ORA-1461 when inserting/updating multiple NCHAR columns
• Default value for a checkbox substitution variable did not work
• Drag & Drop from the Object Browser to the Test Manager did not work
• Custom syntax highlighting through Plug-In interface works again with different styles (highlighting Plug-In)
• $ and # will be recognized as keyword characters for word select and highlighting
• Variables Window will remember size and position