Fixes

• Querying a table with LOBs or Objects on Oracle21c would raise an error.
• Queries on Oracle21c could raise an “ORA-24444: TTC RPC (OALL) not allowed” exception.
• PL/SQL Beautifier could add empty lines after “OPEN cursor” statement.
• Opening the “Roles” folder in the Object Browser could display a popup message with the current username.

Features

• Macro playback can now be undone as one.
• PL/SQL Developer will now ask for translation when first run, depending on the Microsoft Windows language.

Fixes

• Import Tables would truncate NVARCHAR2 column values at 4000 bytes for databases with max_string_size = extended.
• The Difference Viewer did not always display national characters correctly when comparing files.
• Clicking on a Bookmark List item did not always work correctly.
• Microsoft Windows Shutdown or Sign out would not stop PL/SQL Developer when selecting “don’t save”.
• Windows Shutdown or Sign out would ask to save modified Workset files.
• The PL/SQL Beautifier did not format the bind variable list for an “OPEN cursor USING” statement.

Fixes

• Fixed an editor memory leak.
• File > Save All did not work for unchanged database sources.
• A floating Bookmark List could be empty after startup.
• The Difference Viewer popup menu had incorrect menu items.
• Selection > Uppercase/Lowercase did not interpret quotes in comments correctly.
• The Editor Find function did not always scroll the search result into view.
• The custom toolbar button for the Workset Apply function would be too large.
• Ribbon group images could be blank if the main window was too small.

Fixes

• The “Test” function on Oracle 18 and later now correctly declares %ROWTYPE parameters.
• A startup delay could occur when the default printer was not accessible.
• Report results could not be copied with Ctrl-C.
• The User Defined Tools “Execute” and “Help” button did not work.
• The Find dialog could incorrectly copy text selected in the editor.
• Editor search hits were not always immediately visible when too far to the right.
• Load Desktop, Crash Recovery and Load Workset will not retry failed connections.
• PL/SQL Beautifier will now align exception declarations with variable declarations.
• Column aliases in View DDL did not use quotes for mixed case column names.
• File Browser and window version control status were not updated after File > Save As.
• Template popup menu could be empty (after long time or hibernate).
• Reopening a Workset immediately after closing it did not show the last changes.
• The Git status of files in subdirectories were not always up-to-date in the File Browser.

Features

• Added a “Show docking animation” preference.
• Added the ability to perform an incremental search in Object Grids by typing the object name.
• Improved the performance of the “Window: Next Used Window” function key.

Fixes

• Find & Replace no longer overrides previously entered search text when selecting text in the editor.
• Fixed an issue where the Test Window SQL Output grid did not clear the sort indicators when executing a new query.
• Fixed an issue when viewing a column value with an external tool, no error was displayed if the tool fails.
• The Difference Viewer will now open at the same line as the current editor if applicable.
• An existing Difference Viewer Window will now be updated when comparing the same file or object.
• The Register form fields could be blocked.
• The Find form buttons are now disabled if no other window is active.
• Some controls could be incorrectly scaled when the Monitor scaling was changed.
• The Unicode header (UTF8 BOM) for export files could be incorrect for some system locales.
• When describing a table with a long multi-line comment, the column list could be invisible.
• The Copy function of the Debugger call stack only copied the selected stack item.
• Fixed an issue with Crash Recovery that would show all details as “?”.
• The PL/SQL Beautifier did not uppercase keywords with a minus (e.g. -SUM).
• Closed Template windows could re-appear when Windows wakes up.
• Fixed some memory/resource leaks.
• Updates and News could have a dark blue background on the first item in the 64 bit version.
• A “to_date without format” hint could occur when disabled in the preferences.
• When searching for plain text with the regular expression option enabled, spaces are now accepted without a \ escape character.
• The Command Window will now stop execution of a script if “whenever sqlerror exit” is used and a connect fails.
• The Command Window connect command could not directly connect with an externally identified user.
• Assigning a schedule to a job could fail with “ORA-01847: day of month must be between 1 and last day of month”.
• Code Assistant context description did not work for lowercase partial object names with international characters.
• The AfterConnect.sql script would not always be executed in Dual Session mode.
• The “Test” function on Oracle 18 and later would declare PL/SQL Table parameters as “table” instead of the actual data type.

Features

• Language packs updated for 14.0 features.
• The Project desktop file (project.dsk) is now portable.
• File Locations import/export functions added.
• File Browser directory popup items added for Git Clone and Subversion Checkout.
• Change All Lines popup menu item added to the Diagram Window.

Fixes

• Large Data Editor did not show in Single Record View in the SQL Window.
• Selection > Uncomment would remove /* and */ in string constants.
• Window List did not conform to the "Short Text" setting for Difference Viewer windows.
• The Difference Viewer window did not always have a correct title.
• Cut and Paste did not work in the SQL Window in Single Record View.
• Code Assistant would display urowid parameters as "Unknown type 104".
• Table Definition Editor Index Column Selector would convert string expressions to lowercase.
• Entering a value with square brackets when executing a template would interpret the square brackets as a variable.
• Key Configuration items for File / New / Program Window were missing.
• The Command Window BEAUTIFY <file> command did not conform to the Files / Format / Linebreaks preference.
• Using the "SQL Window: Hide Editor" function would incorrectly reposition the vertical splitter.
• The Debugger did not always show correct variable values in local subprograms.
• Object Browser Filter "My invalid objects" would raise ORA-00918 when opening the Triggers folder.
• Clicking on Window List items did not always work correctly after changing the display.
• Fixes for multiple monitors with different display scaling (file selector, print dialogs, MDI window title bars, scrollbar width) were not available in the 64 bit version.
• The "Close unused connections" preference could cause delays when closing a window or when changing the main connection.
• The Quick Access Toolbar in Full Screen mode on Windows 10 was transparent.

Features

Built-in Version Control support for Git and Subversion

• If you are using Git or Subversion (SVN) for version control, you can now make use of the built-in version control functions in PL/SQL Developer.
• The version control status of a file (untracked, added, modified, unchanged, …) will be displayed in window status lines, in File Browser items, and in Project items.
• Version control operations can be performed directly in a window by clicking on the version control status icon.
• In the File Browser and in a Project you can right-click on an item to perform a version control operation.
• For these file control operations PL/SQL Developer relies on a 3rd party shell extension that must be installed on your system. In the screenshots above “GIT Extensions” has been used.

Worksets

• A workset is a set of Program Windows, SQL Windows, Test Windows, Command Windows, Report Windows and Diagram Windows that you are working on. Changes made to these windows are preserved when closing and reopening PL/SQL Developer, even if you have not explicitly saved or compiled these changes. After finalizing your work you can apply the workset, so that changes to the files and database objects are permanently saved.
• A workset holds the window contents, sizes and positions. When a workset is reopened later, windows will be restored exactly like they were previously used.
• When using multiple worksets you can easily switch between them, or use the workset=<name> command-line parameter.
• All workset-related functions are accessible from the Workset group on the File ribbon:

Internal difference viewer

• Several PL/SQL Developer functions allow you to compare 2 texts and display the differences. These differences can now be viewed in an internal difference viewer, instead of relying on an external tool.
• The new viewer allows you to ignore differences in case and white space as usual, but it can also ignore differences in comments.
• For modified lines it will mark the exact differences within the lines.

Program Window enhancements

• The Program Window now highlights transaction statements, so that you can visually recognize the code that affects a transaction. As soon as you place the cursor on a transaction statement, all related statements within a program unit will be highlighted.
• Using the “Test” and “Describe” functions in the Code Contents of a Program Window now automatically selects the correct overloading.
• A preference option has been added to prefix filename with owner when saving a database source.
• Performance has been improved when fetching large database sources over a slow connection.

Debugger enhancements

• A variable name and value can now be copied to the clipboard through the new “Copy variable” popup menu item.

Editor enhancements

• A function key “Editor: Refresh Code Assistant” has been added, to bring the Code Assistant up to date after creating new database objects.
• When selecting a word, all matching words will be highlighted.
• Marked editor text is automatically copied to the search field of the Find function.

SQL Window enhancements

• You can now display multiple result sets simultaneously and can compare them.
• CLOBs and BLOBs are now fetched on demand to improve query performance.
• Single record view will now show column comments if available.
• The EXCEL and CSV export filenames can now include substitution variable values.
• The EXCEL and CSV export filenames can now include %time%, %hh%, %mi% and %ss% variables.
• For the “Export Results as SQL file” function you can now customize the initialization and finalization.
• The WITH_PLSQL hint is now supported.

Command Window enhancements

• New EXPORT TABLES and EXPORT OBJECTS commands have been added. This allows you to automate frequent export jobs. You can easily build the command-line from the interactive export tools.
• The BEAUTIFY <file> command now supports wildcards.
• The CONNECT command now shows the database list after typing @.
• The WITH_PLSQL hint is now supported.

Object Browser enhancements

• The Object Browser will now show all overloaded versions of functions and procedures.
• You can now filter on multiple comma-separated object names (e.g. “dept%, emp%”).
• You can now refresh materialized views from the popup menu.

File Browser enhancements

• Git and Subversion support has been added.
• File icons now indicate the PL/SQL Developer file type.
• You can now filter files based on the name, size, date, read-only status, and version control status. You can specify the filter in the options dialog.
• You also can enter the filter expression directly at the top of the File Browser.
• All windows shell functions are now available from the popup menu.
• You can now create a specific PL/SQL Developer file type from the “Create File” popup menu item.
• You can now add multiple files to a project at once.

Project enhancements

• Git and Subversion support has been added.
• File icons now indicate the PL/SQL Developer file type.

Table Definition Editor enhancements

• The Index and Partition storage can now be edited, copied, and pasted directly in the grid.
• Support for Row Archival has been added.

Test Manager enhancements

• You can now add multiple Test Script files at once.
• You can now drag and drop Test Script files from the File Browser.
• You can now enable or disable multiple items at once.

Connection List enhancements

• Window icons now indicate the PL/SQL Developer window type.
• Connection status icon moved to the left for consistency.

Session Window enhancements

• You can now define Session Actions that can be performed from the popup menu of the session list.
• Session Actions can display feedback by writing dbms_output.

Other enhancements

• Function keys have been added for “Search Bar” functions (Focus, Search, Go to next, Go to previous).
• Substitution variable checkbox and list values can now refer to other variable values as &variable.
• An “Unregister License” function has been added.