PL/SQL Developer

For a description of the new features in version 14.0, visit the New Features page.

Enhancements

• Stability improvements
• After exiting PL/SQL Developer, a plslqdev.exe process could remain
• Excel export functions now pass dates before Jan 1, 1900 as text to prevent conversion errors
• When copying and pasting a row in a SQL Window result set, line breaks would disappear
• View Error Stack function could truncate the stack when it is very deep
• Oracle Error messages longer than 1023 characters would be truncated
• Right Margin preference did not immediately apply to open editors
• Substitution variable IFEMPTY clause now supports select statements with bind variables to reference other substitution variables
• Objects lists did not respond to object function shortcuts that included the Enter key
• Cursor loop variables were not always described by the Code Assistant
• Connection indicator did not have the correct size after a display DPI change
• View stack dump function performance improved
• Table drag & drop function for “Insert” and “Update” would include virtual columns
• Hint popup would not always disappear when using Alt-Tab

Enhancements

• Stability improvements
• Added horizontal mouse wheel support to the editors and grids
• File dialogs to select a Test Set or Test Script in the Test Manager incorrectly allowed multi-select
• Crash recovery did not correctly restore recently used project files
• You could not select multiple files in the File Browser with the Shift key
• Long single-line exception messages could be truncated in message boxes
• Tree view indent could be incorrect after changing the display scale
• Debugger “Execute SQL” function did not show a result set for a WITH statement
• Execution in a Command Window did not immediately enable the Break button
• Recently used file list did not work correctly within the scope of a project
• Changing the connection of a window could affect the “Compiled” indicator of other Program Windows for that connection
• Command Window CONNECT command would show the connection info twice in Single Connection Mode
• Code Assistant could show select loop variable field list beyond the scope of the loop
• Test Window bind variable scan function could fail when using q'<string>’ expressions
• Table.column highlighting did not always work within if-then-else statements

Enhancements

• Stability improvements
• Using the Find function in the Text and XML tabs in Plan Window did not work
• Reloading a desktop or project would lead to too many calls to dbms_application_info.set_module() for the primary session
• Hyperlink navigation and declaration hints did not work for SELF.<NAME> in a type body
• Exporting Unicode data with a file header with non-ascii characters (e.g. in a German month name with umlauts) would cause an error when opening the export file
• SQL Window execute selection would execute all if the PL/SQL Beautifier option “Before compiling” was enabled for SQL Windows
• Displaying a package variable in the debugger from within a standalone procedure could result in “Not a variable”
• Debugger could not step through program unit code with a mixed case object name
• Test function for a mixed case program units did not generate a Test Script
• Debugger could not show attribute values without SELF prefix
• Debugger could not show mixed case variable values with a package prefix
• Mixed case program units were not reloaded with the Autosave Desktop option
• Package elements are now displayed with original case in the Object Browser
• Test Manager recent file list did not work
• Test Manager now displays a warning in case of duplicate descriptions
• Object Browser right-click performance improvement when many objects are displayed
• Debugger will now show the attribute values when holding the mouse cursor over SELF
• Holding the mouse cursor over a selection in the debugger will show the value of the selected expression
• File Browser would incorrectly show parent/child locations in subdirectories
• Crash recovery form did not have an icon on the taskbar
• Test Window Profiler tab page could display error “xxxxxxxxx is not integer value” (64 bit only)
• Backspace did not work correctly in text editor column editing mode
• Window List did not properly handle all dynamic display scaling changes
• Editor performance improvement when navigating text with many highlights

Enhancements

• December 19, 2017 – Version 12.0.7 released
• Executing a select statement in the Command Window could rollback an open transaction
• Startup performance improvement when using a large/slow template directory
• Performance improvement when using many connections and connection folders
• Compare Table Data tool would commit every record in “update database” mode when using a commit interval
• Using the Auto Refresh function in the SQL Window would prompt for substitution variable values for each refresh

Enhancements

• Performance and stability improvements
• Preferences / Logon History / Fixed Users did not work correctly when using multi byte characters
• Window List did not scale correctly when moved between monitors with different DPI settings
• Key Configuration for “Log on” functions did not work for some system locales
• Startup Splash screen and Connection screen now show a taskbar icon
• File type extension registration did not always work correctly
• Object names with a “+” were not automatically surrounded with double quotes.
• Find Dialog could disappear when switching focus from the editor
• Comment Selection did not handle quotes in comments correctly
• Plug-In function IDE_CreatePopupItem now also supports the Plan Window
• Could not log on when ORACLE_HOME environment variable was set to an incorrect directory
• Editor Column Editing did not always work correctly
• Editor Keyword Case was not always applied after typing parentheses
• Shortcuts for File / Open / New / Program Window / … did not work
• Command Window BEAUTIFY <file> command did not use the current directory from the CD command
• Command Window cursor was not always located correctly after the prompt
• Connecting the PL/SQL Developer main connection from the Command Window would show “Not logged on” as feedback
• File Dialog and Find Dialog could incorrectly show up after unlocking Windows
• An error message about “GetTickCount64” could appear when starting PL/SQL Developer on Windows XP

Enhancements

• Language packs added for Brazilian, Chinese, French, German, Hungarian, Japanese, Russian and Spanish
• Performance and stability improvements
• Refreshing a result set after executing one of multiple statements of a SQL Window script would remove all other statements from the script
• PL/SQL Beautifier did not parse q’strings correctly when not using brackets and the 2nd character is a quote (e.g. q’*’hello’*’)
• Regular expression popup menu had a double entry for the Tab character (\t) and no entry for the Newline character (\n)
• Insert column value highlighting did not work when using a RETURNING INTO clause
• Debugger preference lists “Never/Always add debug info” now also support comma and semi-colon as separator
• Selecting a mixed case table column name in the Code Assistant did not add quotes
• File Dialog enhancements:
  • Entering “.” will refresh directory
  • Entering “..” will go up one directory
  • Pressing F3 will focus the Search field
  • Pressing F4 will focus the file edit
  • Pressing F5 will refresh directory
  • Column layout was not saved correctly for international windows versions
  • Entering characters in the file list did not always jump to the corresponding file
  • Connection option is now disabled when “Allow Multiple Connections” preference is disabled
  • Directory shortcuts were not displayed in the file list
• Command Windows script execution performance was poor when many connections are defined
• Search Bar option “Search in files” did not always work correctly
• SQL Window comment directives EXCEL=<file> and CSV=<file> now also support %dbuser% and %dbname% variables
• Connection List could show duplicate connections
• Command Windows script execution performance improved
• Function key added for “Editor: Sort Code Assistant”
• Application title did not show a proxy user
• Find Dialog and File Dialog could show up when switching focus to PL/SQL Developer
• You could not cancel AutoRefresh for a window if the connection fails
• Splash Screen now always displays on monitor where application starts
• Taskbar label did not always start with the connection on Windows 7 in MDI mode
• Debugger could hang when the Anonymous PL/Block of the Test Window had a compilation error
• Starting PL/SQL Developer maximized on secondary monitor did not display correctly
• Selection indent and unindent would take too many steps to “undo”
• Compare Table Data and Compare User Objects SQL preview was not always complete
• Command Window SERVEROUTPUT settings were not preserved when reconnecting
• Error message after failed registration could be off-screen

For a description of the new features in version 13.0, visit the New Features page.

Enhancements

• Find & Replace functions in did not work in a Macro
• Compile referencing objects did not show all invalid objects
• Selection Upper and Lower case did not work in a Macro
• Export Tables in Oracle format did not work when multiple tables were selected
• File > Close All could cause an Access Violation
• Window List function “Close all other Windows” could cause an Access Violation
• Project > Save button was not always immediately enabled when modifying project properties
• SQL Window did not parse multiple statements with Q’Strings correctly
• Executing a script in the Command Window with dbms_output would always display an empty line before the output
• Scripts generated by Export User Objects and Export Tables did not always include headers

Enhancements

• Stability improvements
• Projects with AutoConnect enabled did not always open files for the specified connection
• Change window type could add an incorrect Unicode BOM character to the text if file encoding preference is set to “Always UTF8”
• Ctrl-Home did not work on the first editor line
• Test Window execution would fail with ORA-01742 if the script ends with a /* */ comment
• Saving recovery files could lead to screen flickering in SDI mode
• A read-only Program Window did not reload a changed program unit when prompted
• Large Data Editor “Save to file” function would store ANSI CLOB data as UTF16 when connected to a Unicode database
• Plug-In function IDE_GetWindowObject only worked for a Program Window and SQL Window
• Code Assistant (all) option could be missing when using subselects
• Drag & Drop from the Object Browser to the work area did not work
• Code Assistant did not work for externally identified users in combination with a proxy account
• Editor popup menu “Insert Template” delay fixed for large template directories
• New “Scroll window into view when selected” preference added

Enhancements

• Command Window would hang when opening login.sql without a connection
• Connections tool was missing on the View ribbon
• Indent and Unindent on large text selections in the SQL Window would cause a delay
• Added keyboard access for large report menus
• Clicking on a […] cell button in the SQL Window result grid while pressing Ctrl could cause an Access Violation
• Right-clicking in the Beautifier Rules preview would display an empty popup
• ORA-28055 (the password will expire within <n> days) was not handled correctly
• SQL Window did not parse “with procedure … select …” correctly
• Large Data Editor could add cr/lf to a multi-line text
• Selecting an overloading in the Code Assistant with the left and right key did not work correctly
• Code Assistant and Debugger showed empty items in record descriptions with subtype fields

Enhancements

• Stability improvements
• User interface preference “Switch to menu” now uses a classic menu bar
• Bookmarks could disappear with Block indent/unindent
• Code Assistant items were not always quoted correctly when choosing (all)
• Debugger could include member function names and member procedure names when displaying object instance attribute values
• Program Window did not always display compilation errors for mixed case program unit names
• Describing object types with mixed case object attributes could fail
• Fixed incorrect unused value hint when a record field was used in a local subprogram
• Fixed empty items in toolbar configuration in the File category
• Loading a previous desktop in SDI mode could show duplicate windows
• XMLTYPE instances fetched on an UTF8 client could be converted to the local character set
• Plug-In function IDE_SetMenuName did not work for the Ribbon and Tab, only for buttons
• Object Browser Triggers folder always used the all_triggers view, regardless of the “Use DBA views” preference
• PL/SQL Clipboard performance improved
• Plug-In Tabs and Groups were not always named correctly
• 64 bit Visual Studio Plug-Ins were not always loaded
• Text Importer could break or stop screen updates
• Drag & Drop table and view texts (e.g. select, insert, update) did not work correctly for mixed case column names
• Insert column highlighting did not always work correctly for select lists

Enhancements

• Stability and performance improvements
• Support added for Oracle 12.2 long identifiers
• Code Assistant did not add quotes for mixed case table/view column names
• Oracle Logon did not allow you to change the password in case of ORA-28055 (the password will expire within x days)
• Debugger options “Never/Always add debug information for user@database” did not always work correctly when using multiple connections
• Command Window did not look for login.sql in the default directory
• Performance improvement populating the template list
• Code Assistant and Debugger could not describe mixed case object types
• Templates will now have empty query lists when not logged on instead of raising an exception
• PL/SQL Developer could not start maximized when using SDI mode
• When changing the display resolution or monitor (e.g. when docking a notebook) the PL/SQL Developer Window would be restored when minimized, and the minimize button did not work
• Text Importer field selection list size optimized + pre-select next field when clicked
• Sending email from the 64 bit version did not work
• Window List sort order was not always restored correctly
• Loading a text file in the Large Data Editor did not always process the encoding correctly
• Command Window would display empty lines when feedback is “off”
• Warning added when xls export exceeds the 64K row limit
• Window order in the Window List and SDI tabs are now synchronized
• Importing CLOB’s in PL/SQL Developer import format (.pde) could fail with ORA-24508
• File Save dialog could give incorrect “file exists” warning when using Windows Classic Theme
• Code Assistant now inserts view columns without quotes if not needed

Language packs for Brazilian, Chinese, Hungarian, Japanese, Russian and Spanish have been released. French and German will follow shortly.

Enhancements

• Stability improvements
• PL/SQL Clipboard was not updated when unpinned (auto-hide)
• Dockable tool status was not displayed correctly on the “View” ribbon when unpinned / auto-hide
• Dockable tool status was not displayed correctly in the desktop popup menu
• Project option buttons state was not always up-to-date
• A window can now only be added to a project if it is associated with a file or database object
• Null characters suppressed when loading files or pasting text
• Block indent and unindent could move the cursor
• Full-screen mode now also overlaps the Windows taskbar
• The hint for Configure > PL/SQL Beautifier was incorrect
• Program Window did not show compilation errors when not using main connection
• Object names with a colon were not enclosed in double quotes
• Save Layout in SDI mode would affect default window sizes in MDI mode
• Debugger function keys did not work when the call stack list had the focus
• Window connection was missing the “AS SYSDBA” identification
• Recent connections now include the “AS SYSDBA” identification
• Improved Commit & Rollback images
• Opening the Recent Objects Folder could cause an Access Violation
• Mouse navigation was not always possible for the last row in a grid
• Shortcut key conflicts between modeless window buttons and ribbon resolved
• Format XML function in Large Data Editor can now also be used for read-only XML data
• SQL Window Export All to Excel function could cause duplicate sheet names for long query tab names
• The Command list of the Toolbar customization form did not scale properly on high-DPI screens
• SQL Window editor scroll position could move after execution when “AutoSelect Statement” preference was enabled
• Command Window did not display empty lines of fetched multi-line field values
• Command Window spool option did not spool empty lines
• SQL Window “Copy All to XLS(X)” sheet names always had an (index) suffix
• Difference utility could fail with “Error (2)”
• Null characters could be inserted when using a “Keyword Case” Editor preference other than “Unchanged”
• Changes to connection definitions are now synchronized between multiple instances
• Code Assistant did not show local subprograms defined at the same level
• Command Window and SQL Window did not always detect UTF8 encoding for large files
• Note: The Red Gate Deployment Suite for Oracle Plug-In has been removed from the installation package. If needed you can download it from the Plug-Ins page on our web site.

Enhancements

• Stability improvements
• Windows date format was not always determined correctly
• A disconnected main session could log on when activating a Program Window
• Toolbar changes were only saved if the “Autosave Desktop” preference was enabled
• There was a “Blank” item in the “File” category of the Ribbon configuration
• Project > New now shows a “Close current project?” option when appropriate
• Double-clicking on an empty area in the Connection List would activate the currently selected connection
• Project Items dialog “Open” and “Remove” buttons were enabled when there were no files
• Using a desktop=<name> parameter for the first time in version 12 did not always load the correct files

For a description of the new features in version 12.0, visit the New Features page.

Enhancements

• Increased security when downloading updates (https, domain restriction)
• Querying embedded object attributes could display value errors

32 bit specific

• None

64 bit specific

• Grid text cursor placement could be off when using Segoe UI font

Enhancements

• Performance and stability improvements
• After exporting in the SQL Window, a subsequent query could cause an “Index out of range” error
• Preference export did not warn when overwriting a file
• Connection import will now accept non-encoded passwords
• Command Window “Disconnect” command did nothing in Single/Dual Session Mode
• Update to null in a merge statement could show incorrect “comparison with null” hint
• Command Window BEAUTIFY command could clear the source file in case of an error
• SQL Window reported incorrect error location if a statement starts with spaces

32 bit specific

• National characters could not always be entered in the SQL result grid
• Toolbar “Large icons” option enabled for High-DPI screens
• Changing the main connection could cause “Invalid index” error message
• Windows 8.1 and Windows 10 versions are now correctly displayed in Help > Support Info
• XLSX export speed improvement

64 bit specific

• Copy text could include a background color for spaces
• Export all as xls/xlsx could raise an error about identical sheet names
• Crash recovery saved separately for different Desktop parameter values
• Crash recovery file can be opened by drag en drop from the Windows Explorer to PL/SQL Developer
• Command Window spooling did not work correctly
• Command Window spooling now supports UTF8 encoding
• SQL Window Copy All to Excel would include empty sheets for SQL statements without result sets
• The plsqldoc Plug-In did not install all template HTML files correctly

The 64 bit version of PL/SQL Developer 11.0.4 has been released.

Enhancements

• Performance and stability improvements
• Export to XLSX did remove leading and trailing spaces from data
• Find and Replace would keep incrementing number on status line when nothing was replaced
• When using date/time selector in the SQL result grid, PL/SQL Developer would lose focus
• The file format encoding preference “Always as UTF8” did not work for the Program Window
• Crash recovery saved per InstanceName parameter value
• Shortcut key assigned to object functions could insert a character in editor
• SQL Window “totals” comment directive did not use “sum” as the default function
• Ctrl-C did not work in HTML viewers when “Use Internal HTML viewer” preference was not set
• Code Assistant Multi-Select now also available for a table alias in a select list
• Crash recovery could lead to a filename error when using a multi monitor setup
• Double-clicking on a packaged function or procedure could lead to a “Function not valid” error message
• Logging off a session did not update the transaction status in the Window List
• Creating new scheduler objects with timestamps could lead to “Could not convert variant” error message
• Command Window addition for batch locking/unlocking of report files:
  • REPORT LOCKFORALL <path> <password> [R]
  • REPORT LOCKFOROTHERS <path> <password> [R]
  • REPORT UNLOCK <path> <password> [R]
  • REPORT LIST <path> [R]
    For the path you can use wildcards or directories.
    Add the R parameter for recursive directory scans.
• Report Window option “Locked for other users” always asked for password
• PL/SQL Parser did not process double quoted identifiers with quotes and comments correctly
• Code Assistant did not work for aliases for table names in double quotes
• Right-click on a quoted “OWNER”.”OBJECT” would not show the object functions in the popup menu
• Object popup menu item “Browse” will now display the Object Browser if necessary
• Tnsnames.ora file with alias list on multiple lines was not parsed correctly
• Editor with long lines and highlight edit line enabled would not draw text correctly
• Using Alt-Down to get a list in the SQL Window result grid could insert a character
• Connection indicator added to the Object Browser for main connection
• Object Browser filter text now also works for user-defined query-based folders
• Viewing job classes on Oracle12c could lead to “ORA-01036: illegal variable name/number”
• PL/SQL Beautifier did not format FORALL/MERGE loop correctly
• Test Window now processes trailing slash of a PL/SQL Block
• Fixed visual scaling issues on high DPI screens on Windows 8 and Windows 10
• Comments are now preverved when using QBE in the SQL Window
• Undo/Redo did not work correctly after using QBE in the SQL Window
• Changing a Program Window connection would not always apply compiler preferences
• Test Manager window title would be cleared when logging off
• Compare Table Data tool now ignores virtual columns
• You can now use comma’s in substitution variable lists and checkboxes by specifying 2 comma’s:
  &<name=”Exception?” checkbox=”raise_application_eror(-20000,, ‘[#]’), null”>
• Substitution variable checkbox unchecked value now defaults to empty when 1 value is given
• DDL for indexes on virtual columns would specify the column expression instead of the column name
• Fixed Session > Set Main Connection menu icon transparency issue
• Using the Search Next function in a macro not always work correctly

Enhancements

• Performance and stability improvements
• Save layout per multi monitor setup preference added
• Ctrl-C did not work in the Session Window
• SQL Window could display an incorrect elapsed time
• Window List no longer brings window to front when closing a window with Shift-Click or Ctrl-Click
• Changing a window with Ctrl-Tab, Ctrl-Shift-Tab and Window menu is now smoother
• Moving project files in groups other than “All” did not work correctly and is now disabled
• DDL for Enabling/Disabling a constraint was not always correct
• Connection Indicator was not always displayed correctly on the toolbar for maximized windows

Enhancements

• Performance and stability improvements
• Key constraints could not be created with both the disable and novalidate option
• SQL Window query with totals was slow
• SQL Window avg column total was not calculated correctly
• Oracle 12.1 documentation added to default Web Searches
• Test Window Input CLOB values could be truncated on UTF8 databases

Enhancements

• Performance and stability improvements
• Alt-Left and Alt-Right navigation keys could add characters to an editor
• Command Window editor could not be manipulated (scrolling, copying, …) when paused
• Ctrl-Tab and Ctrl-Shift-Tab did not follow the Window List order
• Pasting an editor column selection did not work
• Switching to the Trace tab page in the Test Window when not connected would cause an Access Violation
• Optional substitution variables with a restricted list will implicitly include an empty item
• Clicking in the Navigate Forward list could cause a “List index out of bounds” error
• Adding objects to a project could cause an access violation
• License registration did not always work
• Key Configuration was not available for File / New / Program Window / …
• Substitution variables with multi-line lists did not work correctly
• Command-line parameter OldRecovery added for compatibility with 10.0 file location
• Drag & drop files into the PL/SQL Developer IDE did not always work
• Inserting or updating a non-null value for an nvarchar2 column on Oracle12c could lead to a null
• Timer accuracy improved for the SQL Window
• Window List transaction indicator was always “off” when a form is running
• Program Window did not always highlight loop variables correctly
• Searching backwards with “search in” options could cause a hang-up
• Test Window variable grid popup menu items were incorrectly enabled for read-only file
• Selecting a Column Total for the row number column in the SQL Window would lead to an error
• SQL Window Export to Excel did not use the Tab name as defined by “–Tab” comment
• Edit > Special Copy did not always work correctly
• Export Tables list could include items from the recycle bin (BIN$…)

For a description of the new features in version 11.0, visit the New Features page.

Enhancements

• Test Window editor could not undo changes that were made before the last save
• You can now use an Excel=<filename> directive in a comment section of the SQL Window to set the filename for Excel export. Supports environment variables (e.g. %date%)
• Compare Table Data would generate a script with CR/LF pairs for single LF characters in the source table
• Double-clicking on the tab of a docked tool would undock it
• Breaking debugger execution on Oracle11g could cause a hang-up
• Table Definition Editor storage properties did not work correctly in combination with a language pack
• Test Window vertical splitter size was too small

Enhancements

• New SQL Window preference: “Include row number with export and copy”
• Compile Invalid Objects and Find Database Objects now support multiple object selection
• Object Grids now perform double-click action when pressing the return key
• Standard Query form now provides a selection list for the Object owner and Object name
• New command-line parameter “RecoveryDir” to specify the directory for recovery files
• Find dialog would show selection size on the status line when scope is “Selection”
• The redo function did not work in the modal text editor form
• PL/SQL Beautifier would duplicate text when used immediately after deleting a column selection
• Docking windows were not always on screen when switching multi monitor layout
• Compare User Objects could see differences in triggers due to owner prefix in the source
• Compare User Objects could see differences in trailing semi-colons in type specifications
• Special Copy menu items were not available in preferences to assign shortcut keys
• Fixed possible hang-up during Find & Replace All
• File > Reopen submenu item did not have a shortcut

Enhancements

• Startup performance improvement
• Performance improvement when changing the main connection
• Performance improvement opening user selection lists
• Performance improvement fetching table DDL
• Compare User Objects could implicitly enable/disable/drop triggers for selected tables
• A newly created table would be displayed in the Object Browser if the owner is different from the user selector
• Fixed “Control dxDockTemplatePanel has no parent window” error
• Crash Recovery list size corrected and now resizable
• Fixed “Cannot open file docking.ini” error
• To-Do List “Goto” function did not update Code Contents location
• Editor popup menu item To-Do Items > Show List did nothing
• Large Data Editor Text tab page did not display Chinese text with sufficient spacing
• Command Window and Report Window did not display Unicode text in error messages correctly
• Table Definition Editor did not show “compress for all operations” correctly on Oracle 11.2
• Session Window “Auto Refresh” option did not always refresh session list
• Desktop configuration, Project configuration and Crash recovery now include pinned/unpinned window status
• Import and Export Tables tools now restore previously used window size
• Typing owner.name in the Data Generator table name field would discard the owner
• Some text could be truncated on the Project Compilation progress form
• Long identifier marks did not always disappear after correction
• Paste from Host Language now also detects Delphi #$0D#$0A string expressions
• DBMS Scheduler fonts did not consistently follow grid font preference
• Query Plan could sometimes be empty in the Plan Window
• Change password dialog now shows user@database in the title
• Changing the main connection when an unpinned window was executing would block the IDE until execution is finished

Enhancements

• Fixed occasional Access Violation during startup
• Oracle Scheduler View SQL button would always create a Command Window for the main connection
• Debugger SQL could fail for select statements with many columns
• Multiple separator menu items could be displayed for Plug-Ins
• Windows in the Connection List were not always updated correctly when changing the main connection
• Performance optimization fetching table DDL
• Renaming a table owned by a different user would fail with an ORA-01765 error
• Disabled SmartEd 2.0 Plug-In due to compatibility issues

Enhancements

• DBMS Output did not show UTF8 correctly
• Plug-Ins did not always show submenus correctly
• Starting PL/SQL Developer by opening a project file would start several instances of PL/SQL Developer
• Dockable tools would auto-hide when lists or popup menus were opened

For a description of the new features in version 10.0, visit the New Features page.

The Russian language pack can be downloaded from the PL/SQL Developer language pack page and requires PL/SQL Developer version 9.0.4 or later.

Enhancements

• Fixed a resource leak introduced in 9.0.6.1661
• Connection List logon dialog could be slow

Enhancements

• New command-line parameter: InstantClient=<path>
• Connection List now has the same look and feel as other lists
• Command Window spooling from a script file now saves the spool file in the script directory by default
• Command Window spool command did not always work correctly for specific spool file names
• SQL Window Grid did not check string size when entered in the Large Data Editor
• Double-clicking on a file in the Windows Explorer could lead to “List Index out of Bounds”
• The “Add source to editor” function from the Object Browser could cause an Access Violation
• SQL Window did not allow data editing for table names starting with ‘SELECT’
• Performance improvement when “Use DBA Views if available” preference is disabled
• Performance improvement when Code Assistant “Describe Context” is disabled
• Test Window “Start Debugger” button now remains enabled in case of privilege issues
• A variable name that starts with a semi-colon in the debugger watch list would cause an ORA-03113 exception
• Export User Objects tool now adds a “set define off” command to the script
• Export User Objects tool now adds the “force” option when creating views
• Test Window tab pages disabled while running (could cause a hang-up)
• Code Assistant now supports record type constants
• Editor AutoReplace function did not work within comment blocks

Enhancements

• Code Assistant performance improvement for table/view column lists
• Registry tab page if the Support Info screen did not display DWORD values correctly
• A duplicated user did not show role privileges in SQL statements when no new user name was provided
• Object Browser double-click action and drag & drop action could not be defined for database link type
• Subprogram declaration popup could be truncated if it included comments
• Dates < 1901 were not copied correctly to Excel 2007 and 2010
• Selecting a previously logged off connection would not always log that connection on again
• SQL Window and Test Window did not display SYS.XMLTYPE attributes of an object field
• Typing a target schema name in the Compare Table Data tool could cause an “Invalid Typecast” error
• Compare User Objects and Compare User Data did not show the source owner in the generated script comments
• Compile Invalid Objects tool could raise “Null password given” error in single connection mode
• Auto Refresh for SQL Window in single record view could steal the focus from the top window
• Command Window would not allow cursor left beyond the prompt size

Enhancements

• Modifications for German, French, Spanish and Chinese language packs
• Compile Invalid Objects would show no invalid objects when session was killed
• Report Window could not break on field names with international characters
• Pasting a record in the SQL Window result grid could lead to a “Column index -1 out of range” error
• Compare User Objects did not prefix table with target schema when dropping constraints
• Table DDL could be incorrect for object columns when not connected as owner
• Date fields were not always exported correctly to xlsx when am/pm date format was used
• Editor and Grid did not allow Alt-0128 to insert Euro sign
• Initial connection dialog did not always show last username and database
• Define Connections menu added in Tools menu
• Standard Query popup menu did not work for project items

Enhancements

• NLS_LANG and TNS_ADMIN command-line parameters added
• PDF export from Report did not give correct result for screen DPI other than 100%
• Directory preferences now support environment variables
• When using a language pack the default templates were not always found
• Export to Excel as xlsx would not handle AM/PM correctly
• Improved Excel xlsx export for UTF8 characters
• Cursor position in status bar would not always show correct character position with selections
• Pasting data in a grid with a selected column could start on an incorrect row number
• Diagram Window, Items > “Order as created” did not work correctly for added fields
• Character Set Mismatch warning will now only be displayed once for a connection
• Command Window did not interpret alternative quote delimiters
• Code Assistant on lower split editor in Program Window did not always display at the optimal location
• Text Importer and ODBC Importer now convert invalid field names to valid table column names
• Import Table in PL/SQL Developer format could lead to “ORA-01722: invalid number”
• Editor: AutoReplace function key now also works if AutoReplace preference is disabled
• Editing when disconnected could implicitly connect
• DBMS_Output longer than 4000 characters per line would lead to ORA-06502
• Test Window function “Start Debugger” could remain disabled in Single Connection mode
• Opening a Constraint folder could show a message with the query text
• SQL Window performance improved for inline view queries
• Added warning for “expand all” browser items
• Session > Log On could lead to “Null password” error when session is subsequently used
• A renamed Program Window would get its original name restored after saving

Enhancements

• SQL Window Linked Queries did not work for constraint names with Unicode characters
• Session > Log off did not always succeed for the main connection
• Session > Log off could be incorrectly disabled for the main connection
• Command Window “HOST” command did not work on Windows 7 x64
• Setting the main connection in single connection mode is now disabled if one or more windows are running
• Logon did not always work in Single Connection mode
• Logging off with an open Command Window could lead to “ORA-01005” error
• Fixed “ORA-1005 null password” error
• Performance improvement fetching Code Assistant names
• Prevent “List index out of bounds” when clicking on Window List
• Code Assistant now sorts user objects by name instead of type, name
• Code Assistant did not always work for user object lists and object method parameter lists
• Applying a filter to an Object Selection List with no matches would lead to an unusable list
• Smart Indent did not always work correctly when Smart Fill option is enabled
• Compare User Objects with NLS_LENGTH_SEMANTICS=CHAR could cause incorrect differences
• Changing the Table Definition Editor connection in “Single Session” and “Dual Session” mode did not work properly
• Object Selection List filter would accept space as delimiter
• Adding a Test Script to the Test Manager would incorrectly copy the variable value/type
• Adding a User Defined Tool before a main menu item would add multiple menu items
• Searching in Projects could lead to a “file not found” error
• Log Off in Single Connection Mode with DBMS_JOB editor open could ask for password
• Querying BFILE columns could cause ORA-22290
• When restoring windows in single connection mode, different connections could be used
• Toolbar button configuration displayed two incorrect buttons
• Automatic Statistics did not always work after changing a connection
• User Defined Object Browser Folders with object list could show incomplete contents
• Fix conversion error message for Excel export when date format is incorrect
• Object Browser Constraints root folder did not apply user selector filter
• Object Browser Constraints root folder would show constraints from recycle bin
• Reports would not always show sums on breaks
• AfterConnect.sql script was not always executed when changing a window connection
• SQL Window record number column was not scroll locked
• Using Ctrl-C in the Object Browser would not always copy the full object name

Enhancements

• Fixed incorrect post button status after posting & committing a CLOB value in Single Record view
• Fixed “Session Undefined” error
• Queue table DDL could specify ‘ENQUEUE_TIME’ instead of ‘ENQ_TIME’ in the sort list
• Standard Command Window variables _O_VERSION, _O_RELEASE, _USER and _CONNECT_IDENTIFIER were not always defined
• Execute button would not be enabled after logging on in Single Connection Mode
• Popup menu item “Change Window To” would always use main connection for the resulting window
• SQL Window refresh record could fail for tables with an XMLTYPE column
• Fixed “ORA-01460: unimplemented or unreasonable conversion requested” on 9.2 and earlier UTF8 databases.
• Explain Plan for update and delete statements with table alias did not convert PL/SQL variables correctly
• Command Window prompt would not be updated when selecting a connection from the list
• Debugger did not display collection items indexed with a variable
• Typing in the Debugger watch list could sometimes swap the first and second character
• Find function did not work from Support Info dialog
• SQL Window would not show information about posted changes when “Show Dictionary Info in result grid” was enabled
• SQL Window would not always interpret alternative quote delimiters correctly
• Compare User Objects could not apply changes for Views with comments
• Excel xlsx export now uses the current date/time format
• Fixed Project Groups visibility issue
• System privilege “administer resource manager” was not granted/revoked correctly
• Duplicate names were not displayed correctly by the Code Assistant
• Change Window to another type could fail when focus changed to another window
• Log on did not always clear the Connection button in windows
• Reconnecting all windows to another connection now implicitly logs on
• Some synonyms for V$ views were not translated correctly (e.g. v$object_usage)
• Changing a connection of a window would commit the current transaction, regardless of preference
• Export to Excel XLS could give incorrect column formats for second page
• New SQL Window preference: “Refresh posted records”
• Querying a table with a column of an inaccessible type could lead to an Access Violation
• Invoking the Large Data Editor could lead to “The configuration registry could not be read” error
• SQL Window query performance improved
• SQL Window AutoSelect SQL performance improved
• Code Assistant could display duplicate items from CANames.sql
• Performance improvement when loading files from a network drive
• Compare User Objects could not create queue tables by pressing the Apply button
• SQL Window status line would show only the first line of a column comment
• Main connection indicator colors could be set when logged off
• Editor Copy now always uses white background color
• Selecting “Other” from the connection list in a window status bar now directly shows the Logon dialog
• SQL Window performance improvement when executing large scripts
• Explain Plan Window would wait for other queries to finish in Dual Session Mode
• AppData directory is now properly determined (preferences and files are copied from old location)
• Text color improvement for the connection indicator
• Key Configuration could sometimes be cleared
• Explain Plan function would incorrectly remove into clause for field lists with subselects

For a description of the new features in version 9.0, visit the New Features page.

Enhancements

• SQL Window would always print SQL text, disregarding “Print SQL” preference
• Searching within special text (strings, comments) could be slow
• Key Configuration preference could reset to default instead of using the defined keys when using multiple preference sets
• Export to Excel would interpret data beginning with = as formula
• Column names starting with a digit were not implicitly quoted in SQL statements
• Fixed issue with search in selection where incorrect characters could be replaced
• Duplicate items removed from description window
• View/Edit Data for tables with an owner with special characters would not add quotes to the owner
• UTFE characters were displayed incorrectly when Unicode support was enabled
• Loading the Macro Library could fail on Windows 7/Vista, resulting in a “list index out of bounds” error message
• Debugger could hang after an exception on Oracle11g
• Code Assistant can now complete database link names
• Copy all to Excel in the SQL Window would not have correct formatting on the second sheet
• To-Do Item List was not up-to-date when opening a package spec & body

Enhancements

• Fixed Access Violation when dragging & dropping an empty item in the Logon History
• Fixed Access Violation in the File Browser when adding a new folder
• Order of items after “Open All Items” from a project was not correct
• Project Groups could be removed after doing project options
• Find would not work correctly with a column selection scope
• Edit > Selection > Apply Syntax Case/Color Mark/Comment did not work for Column Selections
• Describe Window now also shows the view comments in the header
• Export Tables would change nls_date_format in single session mode and dual session mode
• Auto Replace now supports Undo to continue with “non replaced” text
• Debugger can now show PL/SQL Table elements indexed by a string
• Object Browser could sometimes perform “double-click” action when using the cursor right key
• Unicode characters from DBMS_Output were not displayed correctly
• Right-clicking on an empty area in the Window List did not show the popup menu
• Highlighted search hits are now cleared when editing the text
• Fixed drawing performance issue with Diagram Window in zoomed mode
• DDE now remains enabled for Windows Explorer open command (DisableDDE parameter to revert)
• PL/SQL Developer main window could not always be minimized
• To-Do list would not always be updated when switching editors in a Program Window
• Case expressions could cause incorrect “Unused assignment” hints
• File Browser would not show all files for large directories (>1000 files)
• Support Info showed OCI Version 11.1 on a 10.2 client
• Export Tables tool will limit the line size to 2400 characters in SQL Inserts format for SQL*Plus compatibility
• Reports did not always calculate subtotals correctly
• Compiler Hints could not be enabled/disabled

Enhancements

• Required version for French, German, Spanish, Russian and Chinese Language Packs
• SQL Window print would not always print date in header
• Window List order was not always preserved
• Large Data Editor text could be invisible
• Ampersands in field names would lead to accel keys in grid headings
• User Editor now adds quotes to password when needed
• Object Browser would show duplicate columns when a cluster with the same name exists
• Incorrect “Not all records are fetched” warning could occur in the SQL Window
• PL/SQL Beautifier option “Split join expression before ON” did not always work
• Timestamp fields were not formatted correctly in Single Session Mode

Hotfix for the following 8.0.1 issues

• File > New > Program Window submenu and could be empty
• Object popup menu item “New” could do nothing

Hotfix for the following 8.0.1 issues

• Code Assistant did not work anymore for subselects
• Unpinned dockable tools did not always retract

Enhancements

• Fix for MonitorFromPoint Access Violations
• File Browser would not always sort the files
• Parentheses would not be highlighted when the closing parenthesis is the last character in the editor
• SQL results, Copy To Excel would not wrap at 64K rows
• Exporters have an option for ANSI (plain text) export (a second option in the file dialog filters)
• Session Window headings would be empty after reconnecting to a newer Oracle Server version
• Shortcut for Edit > Full screen changed from F to L to remove duplicate with Find & Replace
• SQL Window could mark edited number fields without scale and precision as invalid (red)
• Project popup “Object Options” is now disabled when not logged on
• Text Editor of the Large Data Editor did not have the editor background color
• When registering file types, Application will also be (re)registered
• Open <cursor> for <with statement> was not beautified correctly
• Declared exceptions were not highlighted in the Program Window
• Variable highlighting and Code Assistant Popup did not work consistently for Triggers
• Changing the window type would incorrectly convert Unicode characters
• Dropping and purging multiple items now has progress bar and Esc option
• Holding the mouse cursor over an indexed item during debugging did not show the value
• System privilege selection list of the User Editor was too small (4 items)
• Resolving table names failed on Oracle Server 9.0.x
• Text Importer, paste data would not always work
• Code Assistant pane could be trimmed by window edge
• Editing Scheduler Date/Time fields could lead to ‘<date/time> is not a valid date and time’ message
• Project Groups now fully support Unicode names
• SQL Window Previous/Next SQL keys did not work when no result grid was present
• Docking panes would retract when popup menus or dropdown lists were displayed
• Query Data and Edit Data functions did not handle mixed case identifiers correctly
• Code Assistant could popup after executing a SQL Window
• SQL Window Column Total > Count now only counts non-null values
• SQL Window Column Total > Sum precision improved for 0.0 results
• Command Window RunTestSet command could not read directory/file names with spaces
• PL/SQL Beautifier “Init Caps” option would capitalize single character prefixes (P_Empno instead of p_Empno)
• Fixed File Browser bug repeating the same subdirectory
• Object Browser Double-click action was unpredictable (would expand/collapse instead)
• SQL Window timer would keep counting while an error message was displayed
• Fixed Access Violation in TreeNode.GetParent
• AutoReplace was only invoked when positioned before a whitespace character
• DBMS Output could not process lines longer than 4000 characters
• SQL Window Export Query Results button would mess up results with multiple result sets
• PL/SQL Developer would give an incorrect “owned by different user” warning with a loaded file when switching users
• Support added for ‘identified by values <encrypted password>’ clause for User DDL
• SQL Window would always print with the Courier fount
• Fixed bug with file names in title and window list and projects when using desktop parameter
• Keywords are now saved under Application Data in the user profile
• When updating a schedule, start_date and end_date could be updated without making a change
• Browser Object status would not always be updated correctly after docking/undocking
• DBMS_Metadata functions did not retrieve UTF8 text on a non-UTF8 client
• Code Assistant would not describe embedded object types (e.g. Person.Address.|)
• The Object Browser did not show columns for Bitmap join indexes
• Window List will draw faster
• LANGUAGE=<xxx.lang> command line parameter added
• Fixed Access Violation in Data Generator
• Copy grid selection did not add cr/lf after the last line
• Command Window would sometimes need <enter> twice to execute recalled statement
• Invoking the PL/SQL Beautifier did not update the Bookmark List
• PL/SQL Beautifier could not parse merge statements with case expressions
• Floating tools could steal the focus after using the Find & Replace function
• Double-clicking a project file will open a new PL/SQL Dev instance
• A newly created SQL Window after pasting a SQL text on the PL/SQL Developer work area could be closed without a “Save SQL Window” warning.
• Code Assistant did not list parameters for locally declared object functions or procedures
• Command-line parameter NoCheckFileDate added to suppress checking for changed files
• SQL Window Copy All To Excel did not set cell format correctly
• Commit/Rollback buttons could have wrong status after a cancelled import
• Project Build could give continuous error message for deleted files
• Comments before a program unit could be indented incorrectly
• Code Assistant popup could hide partially under Windows taskbar and/or sidebar
• New PL/SQL Beautifier rule “Split JOIN expression before ON” added for 7.1 compatibility
• Substitution variable integer validation was limited to a 32 bit integer
• Pipelined functions could lead to incorrect “function does not return a value” hint
• AutoReplace is no longer automatically invoked when typing comments or strings
• SQL Window could give a “not all records are fetched” warning in Single Record Mode
• PL/SQL Beautifier would not always format item lists correctly for a WITH statement
• Search > Replace All did not always work correct (”” replace by ” would give ‘)
• Improved multi monitor dialog positioning
• Execute button was not updated correctly after saving a read-only database source
• Inserting and Updating CLOB’s and BLOB’s through the SQL Window now uses Temporary LOB’s on Oracle 8.1 and later to facilitate trigger testing
• Compare Table Data could update incorrect fractions of a second for timestamp columns
• Code Assistant items can now be sorted
• SQL Window “Save as Template” option could show “Unexpected error” instead of a normal error message
• SQL Window execution time would be displayed during substitution variable form
• Notification time for long running queries would include substitution variable form time
• Object Browser double-click action preferences were not saved for dbms_scheduler types
• Code Assistant would not describe object type columns
• Two quick shift-clicks on the Window List could cause an Access Violation
• Replace All could result in an endless loop
• Hyperlink navigation from a DML statement would sometimes incorrectly navigate to the table or view
• Find menu shortcut keys would not get default values after upgrade to 8.0
• File Browser would sort case sensitive

For a description of the new features in version 8.0, visit the New Features page.

Hotfix for the following issue

• Posting NVARCHAR2 unicode data in the SQL Window could lead to truncated results

Hotfix for the following issues

• SQL Window would not parse statements correctly when immediately followed by comments after the semi-colon
• Compiling a program unit with debug information on an Oracle11g database with PLSQL_WARNINGS=’ENABLE:ALL’ would lead to a PLW-06015 warning

Enhancements

• Fixed some access violations
• Inserting a record in the SQL Window would pass null for Unicode columns instead of omitting it from the inserts statement
• Support for the ODAC instant client added
• Translated help files were not used
• Performance improvements for some dictionary queries
• SQL Exporter did not export very old dates in date format
• SQL Exporter could export floats with comma as decimal separator

Enhancements

• XML editor of the Large Data Editor replaced tabs with spaces
• Files copied in the Windows Explorer can now be pasted in PL/SQL Developer
• Program Window preference “Safe compilation” could not handle quoted program unit names
• Internal HTML Viewer did not process Ctrl-C
• HTML Help indexing did not work for older Oracle versions
• Test Window variable hints would not always be cleaned up
• SQL Window would always switch to SQL tab after execute
• Text Importer would not show correct count if some records failed
• Large data Editor now updates the size while editing
• HTML Book Path was not determined correct under Vista
• Compile Invalid Objects tool could show “Properties of <object> not available” after reconnecting
• Tab order in message boxes with “Don’t show this message again” option was confusing
• Command Window beautify command would save files in UTF-16 format
• New Plug-In functions: BeforeExecuteWindow and AfterExecuteWindow
• Optimization of dictionary view queries
• Fetching View DDL from the dictionary now removes trailing empty lines
• Printed query plans could be truncated
• Folders for Jobs and Queue tables added to the User > Objects folder of the Object Browser
• Preferences could ask for “save changes” when nothing was changed
• Adjusted HTML Help default book selection for Oracle 11g compatibility

Enhancements

• Windows Vista compatibility improvements:
  • Setup is now fully Vista compatible
  • Registering application and file types is now Vista compatible
  • Writing files takes Vista security into account
  • Macro recorder did not work
• Improved indexing method for HTML Help
• Find dialog would not reopen normal once closed minimized
• SQL Window now only handles forward slash as a command separator at beginning of line
• Reloading changed files did not work correctly for SQL Window
• Copy from a grid did not work when “Include Font Style with Copy” preference was enabled
• Copy (without header) added an empty first line
• Replaced sys.all_synonyms & sys.dba_synonyms by all_synonyms and dba_synonyms to allow for private or public synonym replacement for these views
• Table partitions for index organized tables on Oracle9i and earlier did not show
• Source files in Unix format (LF instead of CR/LF) would not always be parsed correctly
• Command Window would not handle “whenever oserror” correctly
• Command Window “beautify” command did not handle Unicode characters correctly
• Command Window would allow mouse to place the cursor before the prompt on the command line
• Large Data Editor, text editor did not wrap text correctly
• Explain Plan Window could not handle XMLQuery with RETURNING CONTENT clause
• SQL Window could not edit data from a table across a database link
• Pressing enter when selecting a substitution variable value from a list would also close the substitution variable form
• Tables from the recycle bin would show up under Users > Objects > Tables in the Object Browser
• User Export Objects with the “Include Owner” option did not include the correct owner for foreign key references to tables of other owners
• FLOAT columns would not include precision
• Copy/Paste in result grid improved to handle quotes better
• Projects could not handle files with comma in path
• Fixed Access Violation when changing window type to Program Window
• Plan Window did not show correct when changing window type maximized
• ODBC Importer could use invalid variable names (based on ODBC field names)
• Command line parameters viewobject and editobject did not work correctly

Enhancements

• 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 a space before the text
• Inserting Templates would add a line break
• Import Tables: clicking on the From/To User combo box would cause “Invalid class typecast” error
• Selection Uncomment did not always work
• Views did not handle Unicode characters correctly
• 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, depending on current 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 an execute
• Import Tables tool did not import Unicode CLOB’s correctly in PL/SQL Developer format
• Find (& Replace) did not work correctly with collapsed code
• New editor preference: “Variable horizontal scrollbar”
• Window List redraw improved (flickering while compiling and speed)
• Large Data Editor: External Editor did not always convert text correctly
• Splash Screen hides after 30 seconds 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
• Text Importer would not handle string fields correct in SQL function # replacement
• 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 due to compatibility issues
• 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)
• Fixed issue with syntax highlighting that could show all highlighting identical
• $ and # and . will be recognized as keyword characters for word select and highlighting
• Variables Window will remember size and position
• Large data Editor, XML Editor did not show node values
• Updated “Roll Up/Down” buttons for Vista compatibility
• Folded code did not unfold when navigating to a compilation error, navigating from the Code Hierarchy, and jumping to a bookmark
• All file dialogs are now Vista style when using Windows Vista
• Object Drag & Drop text now adds an empty line at the end
• Compare Table Data errors would cancel compare operation, even if “Ignore” was selected
• HTML Help window would not reopen correct when maximized
• PL/SQL Beautifier now clears the line status
• Sequence Definition Editor did not allow negative numbers for Min value, Max value, and Start with
• SQL Window result set foreign key lookups no longer fetch BLOB or CLOB values
• Table Definition Editor did not update Tablespace when pressing the Refresh button
• Code Assistant would freeze while a query is running in the same window
• Hyperlink navigation now always centers the target position in the editor
• Right-clicking on a large selection could cause a long delay with 100% CPU utilization
• Copy from result grid would not copy the first empty cells
• Keywords Case setting could result in question marks for Unicode characters
• Added “Copy to Excel” popup option for Statistics in SQL Window and Test Window
• Removed incorrect “SQL File” export option for statistics
• CSV exporter now uses the Windows defined “List Separator” instead of a fixed comma
• <Shift>+<Enter> key will now behave as <Enter>
• PL/SQL Beautifier will handle custom keywords as keywords
• Invalid regular expressions could leave Find Database Objects tool in an unusable state
• SQL Window result grid did not follow the “Use multi-row tabs” preference
• Custom keywords with a dot (e.g. package.function) were not highlighted
• View DDL is now always terminated with a semi-colon
• <Shift>+<Back> will now behave as <Back> in Grids
• Command Window could fail when repeating commands in Single Session Mode
• Starting PL/SQL Developer by opening a document from the Windows Explorer would not always work
• The NOREGISTER parameter now also prevents the “service contract expired” message
• Editor margin could disappear for Java Sources in the Program Window

Enhancements

• Printing could be limited to the first 10,000 characters
• Number keys would not work in editor if bookmark function keys were undefined
• Printing line numbers did not work
• Some characters could be truncated in the editor for smaller font sizes
• AutoReplace now supports templates (right-click in the AutoReplace editor)
• Added an “Editor: AutoReplace” key
• Pressing the <Enter> key would not always work in the Command Window
• Character set detection was not correct for Instant Client
• PL/SQL Editor memory leak & performance issue fixed for large comment blocks when using variable highlighting
• Special Characters preference added
• Table privileges were not editable
• Color marks would disappear when marking a selection
• Fixed issue where PL/SQL Developer would exit/crash on startup
• Find dialog did not show for some windows without an editor
• Registering an expired trial version could give a 6 days left message on the first run

For a description of the new features in version 7.1, visit the New Features page.

Enhancements

• Unicode support added for query results in the SQL Window, Test Window and Report Window
• Added “Unicode enabled” preference
• Test Manager files can now be added to a project
• Esc can now be used to break entering a command in the Command Window
• Support added for WMF/EMF in the Large Data Editor
• XML Editor now shows collapsible code
• Windows that are still executing SQL or PL/SQL can now be forcefully terminated
• Command Line parameter DESKTOP=<name> added to save/load desktop layout
• Find & Replace dialog now shows the replace count
• Report Window now support HTML tags in results to show images, links, and so on
• Expand all and Collapse all popup items added to the XML Editor
• Fixed possible “Range Error” when starting on a PC that was running without a reboot for a long time (>20 days)
• Internal Query Builder would not allow creating relations by dragging columns
• Improved Text Importer data analysis to autodetect fields
• Fixed “Out of resource” errors
• Some configured keys would be cleared after a template window refresh
• Command Window sqlplus command would not add quotes on a filename with spaces
• Data Generator would not handle duplicate functions for the same field correct
• SQL Window grid would interpret specific defined shortcut keys (e.g. ctrl shift p)
• Recovery files would not always get detected/loaded (window handle issue)
• Key preference for Editor <end of line> / <begin of line> is now used (was fixed to Home / End key)
• Adding files to project would not always autodetect file type
• Data Generator handles date conversions better
• Alternate row colors now works properly for sorted grids
• Preferences were stored on startup, possibly overwriting preferences of a second instance
• Continuing a query in a SQL Window with multiple queries could cause “List index out of bounds” error
• SQL Window result grid had lost the ‘fixed’ rown umber column
• Program Window could not parse sources with large amounts of comments before “create or replace”
• Unused parameter/variable hint could be missing if the name was only used as a parameter name
• Hyperlink navigation did not work for table or view aliases
• Recompiling a trigger after a debug session would incorrectly update the trigger source in the debugger
• Session Window columns are no longer reordered for session filter queries with an explicit column list
• MERGE statements were not automatically picked up for the Explain Plan (F5) function
• Compare Table Data would raise “column is not a timestamp” error when comparing timestamp columns
• Placing the Triggers Browser folder in the Tables Browser folder would cause an Access Violation
• Unused assignment hints could be missed when multiple statements are placed on one line
• Shortcut keys for special copy items did not work
• SQL Window Next/Prev record in single record view did not work correct for sorted results
• Collection attributes within embedded object fields could not be queried
• Command Window now spools to preference directory or script directory by default

Enhancements

• Delete Program in Program Window now asks for confirmation
• Text Importer could generate field names like “FIELD__TYPE_”
• Text Importer: added ‘End at line-end’ preference to allow importing records with a different number of fields per line
• Diagram Window fixes and enhancements:
  • “Save as image” and “Copy as image” added
  • Bug fixed with printing/save/copy when scrolled
  • Bug fixed with printing/save/copy which could clip lines at the right
  • Fixed some moving/aligning issues
• Fixed some Query Builder issues selecting fields
• Query Builder did not allow sorting of fields, now possible in “parts” section
• Added a warning for actions on an incomplete result set in a SQL Window
• Fixed some multi-monitor issues:
  • Position of Splash screen / progress dialog
  • Position of message boxes
  • Restoring main window on a specific monitor
  • Windows created on secondary monitor would be positioned wrong
• Logon History could get reduced
• Saving in Unix format could use CR line separator in some editors
• Saving (recovery) files would scroll cursor into view
• Not all key definitions would work in all editors
• Added a “file dialog details view” preference
• Command Window: SET SQLPROMPT added (same as SET PROMPT) with case sensitive [params]
• Macro Library improvements:
  • Fixed bug pasting from one macro to another
  • Selections can now be moved up/down
  • Removed FF items
• XML Editor could have initialization problem caused by registry write access
• HTML Help improvements:
  • Improved detection of description
  • Improved support for Oracle 10 html files
  • Store HTML Document directory
  • Remember selected books after a new build
  • Books were not sorted
  • Search now for separate words (google style)
• Command Window with formatted output did not handle output with linebreaks very well
• Save Layout didn’t work properly for Text/ODBC-Importer
• Compare User and Compare Data could be slow saving large results from editor
• Compare User Objects would sometimes not see dropped columns
• Stack dump would display type specification instead of type body
• View DDL did not include UNDER <Superview> clause
• Large Data Editor was not always accessible in SQL Window with multiple result sets
• Substitution variable escape (&&) did not work if no other substitution variables were present
• Object View DDL could include column aliases
• Empty line could appear for cache clause in Table DDL
• Compare Table Data tool did not always include time fraction of date values
• Refactoring Rename function could not rename exceptions
• Refactoring Rename function would also rename parameter names in procedure/function calls
• Hour Glass is now displayed when connecting to the database
• Locating text in a source from within Find Database Objects would not always find the first occurrence
• SQL Window Single Record view mode preserved with a single result set
• User Definition Editor did not always set Password expire state correctly
• New preference: Files > Format > “Export to Excel with SQL statement”
• Added OnTemplate in Plug-In interface
• Desktop popup extended with some items from the File menu
• Improved auto detection of number/string in Text importer (multiple dots)
• Setting the hot track color to the editor background color would hide all highlighted text
• Clicking on the status line in a SQL Window for a cursor result set would clear the results
• Clearing results in SQL Window will now set focus to Editor
• Bookmark list is now immediately updated when closing a window with bookmarks
• Editor column selection did not work correctly if first visible line was empty
• SQL Window popup menu item “Clear results” was missing for commands without a result set
• When printing with header, a long filename would not always fit
• Text Importer now uses field types from Oracle if possible
• Command Window could not handle REM– as comment
• Support added for Oracle10g alternate quoting (e.g. Q'[Don’t care]’) for syntax highlighting, PL/SQL Beautifier and Code Contents
• Substitution variables could not parse lists that span multiple lines
• The correct preference set would not always be calculated if not connected

Enhancements

• Fixed several ODBC Importer issues
• Fixed “Not enough storage” problem
• Several SQL Window parsing errors fixed
• Added two parameters for HTML books:
  HTMLBooks= to determine the directory for the book index files
  HTMLBookSelection= to determine the path for the book selection
• HTML Export did not use character set and header preference
• Hint preferences grid did not always show scrollbar
• CSV Export did not export null values in the first field(s)
• Report Window layout grid selection lists did not work correctly
• Comments were removed from statements when stored in the recall buffer
• SQL Window would allow tab changes during execution, which could cause errors
• SQL Window fetch buttons would focus editor after completion
• SQL Window “Executing…” message would immediately be cleared
• SQL Window QBE query is now displayed again for scripts with 1 statement
• SQL Window column width and order preserved when re-executed
• Switching from Single Record view could cause “Row index out of range” error for empty result set
• SQL Window could not be switched to Single Record view for cursor result sets
• Preferences menu item groups (at the left) would not always have enough room for contents
• User Interface preference “Autocomplete dropdown lists” added
• User Interface preference “Position messageboxes near mouse pointer” added
• Edit > Next/Previous Tab Page could cause hang-up or error message
• Added Shift-Delete/Insert (cut/paste) in Large Data Editor
• Support for Templates in Explain plan Window popup menu
• Pasting data in Grid could give empty value on next row
• Edit Object Window could not copy/paste grid data
• Explain Plan now also enabled for insert statements
• Comments in the where clause of a browser filter could cause “missing right parenthesis” error
• Double-click on a Job in the Browser would do nothing
• Substitution variable history would override case of entered text
• Copied & pasted authorizations would not be saved when pressing OK
• Plug-In function IDE_ExecuteSQLReport would give “cannot focus invisible window”
• Plug-In event OnPopup was not called for Session Window popups

For a description of the new features in version 7.0, download the New Features document (Acrobat Reader PDF format).

Enhancements

• Fixed an access violation when starting the Query Builder on some Windows versions
• Fixed dbms_output ORA-06502 error on 10.2 for lines > 255 characters

Enhancements

• Compatible with Oracle10g Release 2
• Fixed memory leak in data generator
• plsql_debug mode only applied during compilation to prevent ORA-00600 errors
• Report Window did not recover correctly from killed session
• Improved TIF compatibility for the Large Data Editor

Enhancements

• Add debug information menu option did not work if “add debug info when compiling” preference was disabled

Enhancements

• Insert Template context menu would hide first item and add dummy item
• Insert Template did not show subfolders
• Connection preferences in registry (Logon section) did not work
• Projects: progress while compiling now shows actual number of compilable files (compiling: x of y)
• Projects: not all compile errors were indicated
• Projects: handled errors in command files for WHENEVER … FAILURE
• Added missing Oracle10g plan_table columns
• SQL Window AutoSelect Statement function did not handle nested PL/SQL Blocks correctly
• Command Window could not process “create or replace type … ( )”
• Command Window could not process “create or replace and compile java source …”
• Command Window would insert empty lines when showing dbms_output
• Command Window Show Param[eters] support added (with additional info option)
• Command Window Set Arraysize support added
• Command Window Set Time support added
• Command Window would not exit nested scripts for ‘whenever … exit’
• Command Window now supports environment vars (%var%) for commands with files (spool, @, store, get)
• Sorting a grid did not always sort strings case insensitive
• Compile Invalid Objects initial query performance improved
• Explain Plan Window now allows you to execute alter session statements for the current session
• Explain Plan item was disabled for WITH statements
• Text Editor [Esc] would activate Help
• Inserting templates no longer interprets a “/” when not creating a new window
• Pasting columns in Table Editor would give AV
• External tools now support “as sysdba” in connect string
• All items modified by Find > Replace All are now grouped into one undo action
• Code Assistant could remove spaces typed after a comma
• Using the Find function in the Large Data Editor could suppress changes
• Key configuration preference added for SQL Window: Clear Results
• Fixed problem with missing default keys
• Data Generator could not handle SQL(…) for date fields
• SQL Window column moving was not preserved after re-executing the same or similar queries
• Compile Invalid Objects would ignore objects excluded from debug information
• Application title in the taskbar could be cleared after changing a connection
• Nested if/then/else structures could lead to incorrect “Unused value assignment” hints
• Using table.column%type declarations in a Test Script would cause Code Assistant problems
• SQLPATH environment variable was not used by Command Window
• Fixed incorrect handling of formulas when exporting report to Excel
• Fixed AMPM problem when exporting report to Excel
• It is now possible to create a default user.prefs by placing this file in the default preference directory
• Recent objects folder was not properly refreshed
• Templates for a command window can now indicate to open the editor page [$WINDOW TYPE = COMMAND,EDITOR]

Enhancements

• Package bodies, type bodies, and materialized views would disappear from user defined folders
• Opening a user defined folder when disconnected would lead to “Not logged on” messages
• Reports menu did not show directories with only subdirectories correct
• Instantiable and final member procedures were not displayed correctly in the Code Contents
• Text Importer file associations are now stored in user.prefs, not in Import\import.files
• SQL() function added to Data Generator
• Table creation DDL for partition values ending with a parenthesis were incorrect
• Popup menu in various editors were missing “Insert Template” submenu
• Fixed “cannot convert string to double” error
• Fixed problem with disappearing last row while pasting into grid
• Title of Program Window would not change from View to Edit if Window changed to Edit mode
• Command windows now displays CLOB and XMLTYPE in accordance with the SET LONG setting
• Replace All in Find dialog now also includes the current selection
• Code Assistant could not resolve local variable names in a Test Script or Trigger
• Code Assistant could not resolve variables of a type in another schema
• Command Window and SQL Window will no longer silently retry after “ORA-04068, Existing state of packages has been discarded”
• Using a variable in an exception handler could cause incorrect “Unused variable value” hint
• Double-clicking on a package in the Object Browser could display 2 Program Windows if the package body was wrapped
• Pasting data in result grid did not update NULL indicator color
• Added sound to Warning and Error messages
• Data Generator could give a “list index out of bounds” for Files() function with only one file
• Logon History did not always display all grouped items
• Fixed link to Direct Oracle Access (5 variables limit)
• Copy comma separated from browser would not work for closed folders
• Suppressed dialogs (Don’t show this message again) still gave a sound
• Duplicate reports (same path and file) in reports menu prevented
• Program Window could split source on a slash in the middle of a line
• Dropping an object in the SQL Window would not update the Object Browser
• Replace All was not restricted to the selected scope
• Preference “Wrap to start / end of file when text is not found” did not work
• Using +variable or -variable could cause incorrect “Unused variable” hints
• Command Window now issues a warning when a connection is re-established
• Refreshing the Session Window with a disconnected PL/SQL Developer session would cause errors
• SQL Window always auto-sizes columns unless you have explicitly resized a column
• Recent files list is now passed to a second PL/SQL Developer instance

Enhancements

• Fixed connection delays and ORA-12154 errors when using Oracle Names 9.0 or 9.2
• Using the Large Data Editor could lead to instability
• Some applications could not be started when PL/SQL Developer is running
• Memory overhead in object list reduced (Export User Objects, Compare User Objects, and so on)
• Code Contents parse error fixed when using the words “left” or “right” in a condition
• SQL Window “Next SQL” button did no longer clear the editor after the last SQL
• Text Importer replaced only 1 occurrence of # in an SQL function
• The View function for program units would bring an already opened, editable window to the front and make it read-only
• Creating/Editing users with special characters would fail
• Fixed error while downloading updates & News details
• Preferences are now synchronized between different instances on the same PC
• Fixed problem with copy/paste multi line data in grid
• PL/SQL Beautifier would raise error for table.column expression with a space between table and .column
• XML editor would replace header with <?xml version=”1.0″?> after making a modification
• Large Data Editor could add 0-byte to BLOB data
• Code Assistant did not come up for lower..upper expression without spaces
• Data Generator did not generate master/detail/detail data correct (only test was correct)
• Text Importer would not always handle quotes correct
• Large Data Editor could enable word-wrap in other editors
• Preference for maximum size of recall statement would not always be saved
• Improved the resizing behavior of the Plan Window
• Safe Compilation preference did not work correctly if owner preceded the object name (create or replace package scott.employee …)
• Clear function for SQL, Command, Test and Report Window did not also clear the “Saved” indicator
• Left-clicking on a Code Contents item will now always navigate to the start of that item in the editor
• Preferences will be stored in Application Data Path if the default directory is read-only
• Not all font and color preferences were applied immediately in preference dialog
• Date format preference could be changed externally
• Changing the Session Mode preference could cause errors if PL/SQL Developer is not restarted
• Find dialog would be displayed at wrong position for multi monitor systems

Enhancements

• Partitioned tables were not detected correctly on Oracle8i
• Partitions tab page was visible when viewing a non-partitioned table
• Code Assistant did not describe materialized views
• Code Assistant did not describe record types declared in another package
• Code Assistant could remove spaces typed after a comma
• File -> Close All could lead to invisible confirmation dialog
• Font Bold & Italic preferences did not work for browser and grid
• Key Configuration preference would not handle all keys properly
• Compare User Objects could incorrectly change column properties when column order for source and target table is different
• Large Data Editor had problems with XML data with lines > 65000 characters
• Preference “Use DBA views if available” could cause ORA-00942 after switching from a DBA user to a normal user
• Compilation errors were not displayed when “create or replace” and object name are on different lines
• Could no longer connect with just / for externally identified users
• Deleting a column selection in the editor could also delete adjacent highlighted text
• Dropping a java source from the Object Browser would cause ORA-29501
• PL/SQL Beautifier did not format all ANSI join types correctly
• On Oracle7 Explain Plan and Test function did not replace PL/SQL variables by bind variables
• Text Importer would only import 99 records when pasting from clipboard
• Data Generator did not handle a master with 2 details correct
• UxTheme related errors fixed
• Browser Folders would not save connection property
• TSV Exporter would skip first field if it was empty
• Large Data Editor now closes when pressing Escape
• Compiling a body with a missing or invalid specification with “Safe compilation” preference would give compilation errors with temporary object name
• Hyperlink navigation did not work correctly for compound custom keywords
• Hyperlink navigation did not immediately update Code Contents
• Generating a Test Script for a non-packaged program unit with parameters with user-defined types would not create local variables with correct types
• Dropping an object in the Compile Invalid Objects tool would not update the compilation error list
• Fixed a problem starting specific applications when PL/SQL Developer is running
• Data Generator number precision displayed for fields with a scale of 0 would not be correct
• Explain Plan and Test function now also replaces constants by bind variables in select statement
• Pressing a cell button in an empty Single Record grid in a SQL Window would cause an error message
• Export to Excel could display cells as #### due to column width
• SQL Window now preserves result message after navigating in result grid when “Show dictionary info” preference is set
• Tables folder in Tablespace folder in Object Browser did not list partitioned tables
• Compare User Objects memory usage optimized
• Compare User Objects list included tables from the Oracle10g recycle bin
• Fixed splitter problem and alignment of editor in XML Editor
• Oracle Logon preference “Fixed Users” is now stored encrypted
• Excel interface would not handle Japanese characters properly
• Fixed “Invalid pointer operation” errors

Enhancements

• Support for Oracle10g EZCONNECT added
• Performance of “Copy to Excel” function improved
• DDL for synonyms now uses “create or replace” syntax for Oracle 9.2 and later
• Pressing an “Auto refresh timer” button now immediately executes the Window
• Shortcuts Plug-In enabled again
• Scrollbar in Explain Plan function now scrolls all contents
• Compare User Objects would try to rename columns when column order is different
• Code Hierarchy did not have Explain Plan and Test popup menu items for select statements
• Executing a Report would copy the SQL to the clipboard
• Report would not ask for password when “locked for others”
• PL/SQL Beautifier preview did not show effect of “Wrap zero level AND/OR” option for Control Structures
• Proxy settings added for Updates & News
• Renaming an object in the SQL Window could lead to incorrect “Object has been deleted” message
• Beautifier DML Rule “AND/OR under where clause” was always enabled
• Code Contents could sometimes be blank or out-of-date
• Fixed various access violations
• Explain Plan function did not replace record field PL/SQL variables in SQL text by bind variables on Oracle 9.0 and earlier
• Safe compilation could fail if the package body contains references to objects with the same name in another package
• Disabling the “Include Storage” option during Export User Objects would still include partition storage information
• Text Importer now correctly autodetects text with pipelines
• Large Data Editor now supports undo, redo, find and select all
• Text Importer data preview would not highlight multi line fields correctly

Enhancements

• Program Window enhancements
  • Code Hierarchy pane added
  • Code Contents extended with code structure and hot tracking
  • Compiles in background if session mode is “multi session”
  • Highlight if, loop, case, and blocks
  • Safe compilation preference added
  • Save before compilation preference added
  • Oracle10g PL/SQL Compiler warnings supported
• Support for partitioned tables added
• Support for materialized views added
• Support for compressed indexes added
• Support for reversed indexes added
• Support for queues added
• Support for queue tables added
• Support for NLS Length Semantics added
• Support for LOB and nested table column storage added
• Support for column renaming added (Oracle9.2 and later)
• Editor enhancements
  • Hyperlink navigation now works in all SQL and PL/SQL editors
  • Highlight parentheses
  • Table and View drag & drop into editor can now launch the Query Builder
  • Find function can now wrap to start/end of document if the search text is not found
  • Append function added to append text to the current clipboard text
  • Sort function added to sort a selection
  • Guideline function added
  • SpecialCopy syntax extended with #define compress
  • Multi-line strings properly highlighted in SQL and PL/SQL editors
  • Oracle10g keywords highlighted in SQL and PL/SQL editors
• Code Assistant enhancements
  • Support added for packaged record types and rowsubtypes
  • Support added for cursor variables
  • Support added for select statements on inline views
  • Home / End key will go to top / bottom of the list
  • Wraps to top / bottom from last / first line
• Authorization added
• To-Do Items added
• Data Generator tool added
• New preference dialog with preference sets
• External Tools generalized as External/Session Tools
• New Large Data Editor for CLOB, BLOB, LONG, LONG RAW and VARCHAR2
• Find Database Objects improvements
  • Search for object name, owner, status, creation date range, and modification date range
  • Criteria can be saved and loaded
• Export User Objects improvements
  • Include Storage option added
  • View button added to view the resulting script
• Compare User Objects improvements
  • Option added to include storage in generated DDL for new objects
  • Table column renaming supported (Oracle9.2 and later)
• Export Tables improvements
  • Include Storage option added for SQL and PL/SQL Developer format
  • Include Privileges option added for SQL and PL/SQL Developer format
• HTML Manual enhancements
  • Multi-tabbed search results
  • Roll up / roll down buttons
  • Search text history
• Object Browser enhancements
  • User defined folders added
  • Folder hierarchy
  • Folder color
  • Connection specific folders
  • Add/remove objects through right-click in Object Browser
  • Super/Subtype displayed for type objects
  • Column renaming added (Oracle9.2 and later)
  • Dropping a user that owns one or more objects is now possible after an explicit confirmation
  • Object popup menu now shows the debug information status
  • Recycle bin added for dropped tables on Oracle10g with Purge and Restore functions
• AutoRefresh option added for Session Window, SQL Window, Report Window, Test Window, and Command Window
• Added “Change Window to..” to popup menu for SQL Window, Program Window, Test Window, Command Window and Report Window
• SQL Window enhancements
  • New number layout preference: “Formatted with thousand separator”
  • New “Null Value Color” preference
  • Object Browser is immediately updated after creating / dropping / altering and object
  • Compiling a view will save & restore instead of triggers
  • Query can now be saved as “Standard Query” for a Table, View or Materialized View
  • Direct XMLTYPE query support on Oracle Net 9.2 and later
  • Saving a view source now provides the view name as default filename
  • Clear, Clear Result and Select All added to popup menu of Single Record view
  • ReadOnly substitution variables added
  • Hidden substitution variables added
• Test Window enhancements
  • New debugger preference “Never add debug info for objects”
  • Current debug line is now centered
  • Watches are saved and loaded with the Test Script
• Plan Window enhancements
  • Copy function prefixes each item with its name
  • Oracle10g columns added
• Command Window enhancements
  • Set prompt command added
  • Exit command can now exit PL/SQL Developer
• New PL/SQL Beautifier options
  • Parameter declaration: List at left margin
  • DML: Split at zero-level AND/OR
  • DML: AND/OR after expression
  • DML: AND/OR under where clause
  • Control structures: Split at zero-level AND/OR
  • Control structures: AND/OR after expression
• PL/SQL Beautifier enhancements
  • Support for Merge statement added
  • Support for Join syntax added
  • Constants are aligned when “Align declarations” is enabled
• Recall Statement enhancements
  • Buffer size and location Preferences
  • Export to CSV file
  • Find function
• Oracle10g Instant Client support added
• All combo boxes now have AutoComplete functionality
• Taskbar icon now only displays connection information
• File > E-mail item added
• Keyboard search in property windows
• Popup menu added to the desktop with some primary functions
• Rollup button added to Window List and Template Window
• Shift-click in Window List closes the selected window
• New command-line parameters
  • commandfile: execute a command file
  • viewobject: view database object
  • editobject: edit database object
  • nolugins: don’t load Plug-Ins

Bugfixes

• Oracle10g related fixes:
  • HTML documentation was not indexed correctly
  • Oracle Home was not correctly detected on an Oracle10g client
  • Explain Plan Window caused ORA-01986 errors
  • Debugger now requires DEBUG CONNECT SESSION system privilege
• Improved Direct Oracle Access Interface:
  • Fixed problem when returning more than 5 variables
  • Fixed possible lock when sending back modifications
  • Starting PL/SQL Developer from within Delphi/C++Builder could cause exception

Bugfixes

• Could not use LOB’s or Objects on Oracle10g
• Number precision would be incorrect on Oracle 9.2.0.4 and 10g
• Fixed Plug-In function IDE_GetPopupObject from Plan Window
• Fixed Command Window problem with quotes in comments
• Program Window preference “Ignore Unrecognized PL/SQL” added
• Displaying a collection column or attribute from a cursor result set in a Test Window would lead to “Not logged on” error message

Bugfixes and enhancements

• Multi-Monitor support added
• Selecting an item with username and password from the list will now immediately connect
• Fixed several Access Violations
• Edit > Redo would redo all changes
• Command Window fixes:
  • Help command now uses html help (or supported commands for help ?)
  • When executing a command file from the clipboard, Echo would always be on
  • Timestamp values could not be queried
  • Executing commands in dual or single session mode while another window is running would cause hang-up
• Code Assistant fixes:
  • Did not use original case for local constants and program units
  • Would remove spaces and tabs until the next word on the same line when inserting text
  • Limited to 1000 items to prevent performance issues
• Crash recovery fixes:
  • Application title would not be correct
  • Maximized windows would not be restored correct
  • Suppressed redrawing of window list when saving recovery files
• File > New Instance no longer passes userid parameter
• Report Window would always have all edit menu options enabled, unrelated to selected tab page
• Program Window “Clear Errors” now also clears highlighted error line
• Editors would not see text drag & drop as a change
• Result grid in SQL Window would allow cut and paste, even if locked
• Fixed setup problem on multi-monitor systems
• Saving a file under another name within a project, did not enable “add to project” menu item
• Fixed report problem when sum per break would coincide with pagebreak
• Disabled Export items while exporting
• Test Window would not show output when package state is discarded
• Joined substitution variables (&var1&var2) would not be processed correctly in SQL Window, Report Window and Command Window
• Generating a Test Script for a method with a collection attribute would result in incorrect PL/SQL
• Library did not contain trailing / when exported, which would cause an error when the generated script is executed through SQL*Plus
• Selecting a SQL statement including the trailing semi-colon could cause ORA-00911 error
• Fixed “Beautifier caused an error” for alias[space].field expression
• Bookmarks and breakpoints would disappear when using the PL/SQL Beautifier
• Code Contents could fail for concatenated case expressions
• Fixed erroneous cursor down key behavior on last line in editors
• Fixed grid copy issue for specific international (Greek) fonts
• Fixed case sensitivity issue for custom keywords (international characters)
• Added some missing Paste items in popup menus
• Passwords that start with a numeric character are now automatically quoted
• Adding a variable to the watch list while the debugger is executing a step caused a crash
• Job interval field was inadvertently limited to 61 characters
• Program Window name tab was not always correct for packages and types
• Improved Copy/Paste in Grid in single record view
• Not all dialogs supported [Enter] and [Esc]
• When changing Reports or Documents, the main menu items could get reorganized
• Logon history list could have the “Remove” option from the popup disabled
• Record/Object assignments could cause incorrect “Unused value assignment” hint
• Excel export now declares strings to prevent interpretation by Excel

Bugfixes and enhancements

• Released version 1.1.0 of the plsqldoc Plug-In
• Edit button added to description in layout section of Report Window
• Bookmark Next/Previous menu added (with shortcut)
• Load and Save button added to Text Editors
• SQL Window Single Record View now allows sorting
• Query Builder did not update where clause after drag & drop a column name
• Fixed “cursor down at end of editor” issue
• Special Copy definition now has #define to control string character replacement
• Toolbar buttons for external tools did not get enabled/disabled
• Export Tables grid did not sort on dates correctly (incorrect date format)
• Substitution variables had to be declared in order of usage
• Secondary substitution variables did not inherit properties from the primary variable
• Switching to Single Record View with a function key in the SQL Window would not size the column widths correctly
• Code Contents fixes:
  • Could not handle variable declarations with case assignment
  • Could not handle language keyword in declarations
  • Could not handle nested case expressions
• PL/SQL Beautifier fixes:
  • Numbers that start with a decimal point (eg .13) would not be formatted correctly
  • Table.* would not always be formatted correctly
  • Secondary select statements from a Union, Minus or Intersect would be incorrectly indented
  • Could not handle language keyword in declarations
  • Keyword followed by string without a space would cause error (e.g. execute immediate’select * from dual’)
• Command Window could not connect when userid command-line parameter was specified
• SQL Window would set focus to grid when switching tab pages
• Warning for Update or Delete all records now occurs only once
• In Multi-Session mode the AfterConnect.sql script would cause serialization of the first execute of SQL Windows, Test Windows, and Command Windows.
• Canceling a debug session with an infinite loop could cause hang-up
• Large collections (> 1000 elements) could not be viewed in debugger. They are now truncated to 1000 elements, and a warning is displayed.
• XML Export could not handle column names with invalid XML name characters (e.g. # and $)
• Fixed cursor left en right ‘lock’ in single column grids
• Command Window now supports PlugIn command to call Plug-Ins
• Initial object query in Export User Objects and Export Tables could not be cancelled
• Table could not be described when using a join keyword in a select statement

Bugfixes and enhancements

• Released a new plsqldoc Plug-In
• Post changes button in SQL Window was not enabled when cell button was clicked to make a change
• Lookups for check constraints in SQL Window included quotes for character values
• Lookups for check constraints and foreign keys in SQL Window enabled in QBE mode
• F4 could not be used as a function key in the Object Browser
• DDL incorrect for views with check option without constraint
• Case insensitive search did not work with national characters
• Debugger did not display empty string variable values
• PL/SQL beautifier did not format collection element fields correctly (coll(index).field)
• Delete records option of Import Tables tool was not remembered
• Subsequent && pairs (escaped substitution variable prefix) would be replaced by one &
• && in substitution variable value would be replaced by &
• Printing HTML with Internet Explorer viewer now without header, footer and with correct orientation
• Fixed several Access Violation errors
• Plug-In interface updated and documented

Bugfixes and enhancements

• New SQL Window preference: Show Dictionary Info In Result Grid:
  • Column data type, optionality, and comment displayed
  • Lookup for check constraints (col in (value1, value2, …))
  • Lookup for single column foreign key constraints to small tables with less than 1000 rows
• Added option to save backup files in a specific location
• Added Save & Load Object Selection to object grids (Export User Objects, Export Tables, Compare User Objects)
• AfterConnect.sql in PL/SQL Developer installation directory will be executed after connecting a session
• Hints & Warnings can now be cleared in Program Window
• Post Changes button in SQL Window is now disabled when there are no changes to post
• Export in Oracle Export format no longer deletes parameter file in TEMP directory
• Added PlugIn functions IDE_TabInfo() and IDE_TabIndex() to read and set Tab pages
• Connection Indicator Editor background did not work properly
• Excel interface did not handle formatting of numbers correctly
• PL/SQL Beautifier fixes:
  • Caused error for multi-line string parameter values
  • Did not format table list correctly in select statements
  • Uppercase did not work properly for special characters
  • Comments with unterminated strings would be incorrectly indented
  • Object Type attribute declarations were not aligned
  • Single line selection was not indented correctly
  • Did not work correctly on Windows 9x
  • Expressions in insert list items were not always formatted correctly
• Compiler Hint fixes:
  • Record/object assignments could lead to incorrect unused value hints
  • Nested if/then/else could lead to incorrect unused value hints
  • Duplicate variable names in a program unit would cause unused declaration hint
  • Variable names prefixed with program unit name would cause unused declaration hint
  • Incorrect unused value hints when using variables after an exception
• Fixed several Access Violation errors
• Fixed some memory leaks
• Descending function-based indexes would show up ascending
• Find dialog: paste/cut/clear did not work when invoked for a read-only editor
• Copy to Excel did not handle duplicate column names properly
• Editor Special Copy fix Visual Basic: vbNewLine replaces vbCR
• Long (Raw) columns could not be queried when varchar(2000) or longer was included
• Code Assistant “overload” buttons were not always positioned correctly
• Original command-line parameters are now passed to New Instance (File menu)
• Leading and trailing spaces in table/column comments would be removed in Table Definition Editor
• Query Builder would cause AV on “Find Databse Object” Window
• Help button incorrectly appeared for non-Oracle error messages
• External Tools “Save Window” option was not stored

Enhancements

• PL/SQL Beautifier added
• Localization functionality added (Japanese version available, other languages will follow)
• Compiler Hints added for unused declarations, unused value assignments, comparison with NULL, function without return, and to_date without format
• Code Assistant can now use original case for inserted parameters, functions, and so on
• New Code Assistant preferences:
  • Describe standard functions (e.g. to_char)
  • Use original case if possible
• Backup and recovery options added for editor files
• Toolbar button options added for External Tools, Macros and Documents
• Copy to Excel added for SQL Window and Test Window result grid
• SQL Window preference “Date & Number fields to_char” split into 2 preferences
• Special Copy function to convert SQL to 3GL strings
• Command Window enhancements:
  • Support for WHENEVER SQLERROR | OSERROR added
  • Pause execution to single step through a script with command highlighting
  • SET EXECPAUSE ON | OFF added to control pause mode from script
• Report Window enhancements:
  • Export results to XML, CSV, TSV, or directly to Excel
  • System variables in report title (&dbuser, &database, …)
  • Added Format option for number and date fields
  • Added LIBRARY parameter to select report style library file
  • SQL Text can be included in the HTML output
• Connection Indicator can now be applied to editor background or application background
• Export options for Statistics in SQL Window and Test Window
• Find Database Objects now also supports the Job object type
• Query button added to Table Definition Editor
• More robust Oracle Home selection
• Debugger preferences “Never/Always add debug info” now support connection matches (e.g. sys@*)
• Compare User Objects now ignores white space in PL/SQL source
• Support for Interval datatype added
• Timestamp and Interval datatypes supported in Export/Import table data
• Text Editor can now view text as formatted HTML
• Option in template to add brackets (using double brackets [[ or ]])
• Many other minor improvements and bugfixes

Bugfixes and enhancements

• Report Enhancements:
  • Page break added
  • New break option: Break + Header
  • Sum at break/report level added
  • Non breaking space option added
• Support for timestamp columns and attributes added
• Autorepeat buttons in SQL Window
• Key/Index column selector contained an empty entry for new keys/indexes
• Connection Match hint and right-click customization added
• SQL Window could give “list index out of bounds” in single record view
• Command Window did not always find files at preference location
• Added test for valid filename when creating new templates
• Printing Test Window with Page numbers would give two numbers
• Main Font preference now used in all dialogs
• Debugger could hang on startup (Initializing…)
• Table definition editor did not handle multi-line column comments correctly
• Code Assistant could popup after entering a command line in the command window
• Pressing backspace on the command line in the command window could erase prompt if Code Assistant was visible
• If a package or type specification was dropped, the body would remain visible in the Object Browser
• A quoted trigger owner in the trigger source would not correctly be recognized when opening it from the database
• Command Window did not handle comments in a string properly
• Ctrl-F4 from Text Editor closed parent Window
• Foreign Key References did not have table owner prefix in Object Browser

Bugfixes and enhancements

• Function-based index support added
• Test Window now supports Temporary CLOB’s and BLOB’s
• Average time column added to Profiler report
• New Appearance preference: Connection Indicators
• File > New Instance menu item added
• Job What PL/SQL Editor button added
• Job editor now accepts sysdate expressions for Next date field
• Command Window ‘Edit’ command now uses PL/SQL Editor
• When describing or Testing an invalid object, the object will now implicitly be validated
• && can now be used to escape substitution variables in SQL Window and Report Window
• If a trigger fails when posting a record in the SQL Window, the stack dump can now be viewed
• Register Filetypes Help button was missing
• Substitution variables are no longer processed for SQL Window with database source
• Fixed problem with column order when copying and printing some grids
• Profiler and Trace reports did not display trigger source lines
• Profiler report would incorrectly sort time columns if it includes a comma
• File > New > View menu item was missing
• Selections would not be visible when editor background is same as selection color
• External procedures and functions without a language were not displayed correctly in Code Contents
• Popup menu items in Plain Text Editor Window were not always appropriate
• Undo/Redo did not work in Plain Text Editor Window
• Create/Drop database link feedback in the Command Window was ‘External database created/dropped’
• Improved handling of multi-line strings in Command Window
• Command Window pause command now supports a Cancel option
• Command Window set verify command did not always display variables
• Code Assistant did not work for aliases if select statement was in parenthesis
• Code Assistant is now disabled during Macro recording
• Sequence increment could not be negative
• Deferred constraints were read from dictionary as immediate
• Changing a the owner of a table did not propagate to the indexes
• View/Edit private database link did not retrieve password
• Editing a record in Single Record View in a SQL Window could lead to a partially updated database record
• If SQL tab page was not selected in SQL Window, “Cannot focus a disabled window” error would occur if an exception occurred during execution
• Cancel button in HTML Help Setup did not work
• Report Window Locking did not work properly
• Global private package variables were added to the Watch List with package prefix
• Compare User Objects: Target session logon now has history
• Templates: Positioning of cursor was not always correct
• Plug-In function IDE_CreatePopupItem did not work for Browser folder items (TABLES etc)
• Added Plug-In OnWindowCreate() and OnWindowClose()

Bugfixes and enhancements

• User’s Guide provided as on-line help
• Popup menu with Copy and E-mail items added to Compilation Errors pane in Program Window and Compile Invalid Objects Window
• Fixed problem with assigning shortcut keys with Alt
• Fixed problem with substitution variable lists with a query bind variable that has more than one occurrence in the SQL Text
• Cut was not possible in Query By Example mode in SQL Window
• Functions involving table definitions could lead to ‘not a valid integer’ error
• Compare User Objects did not ignore index storage properties
• Printer initialization could fail during PL/SQL Developer startup
• Type owner and name could be changed when viewing an object table definition
• Right-click on an index in Explain Plan Window did not show index object popup
• Files associated with PL/SQL Developer did not always have an icon
• Command Window: define could not set empty values
• Plug-In interface: IDE_CreateWindow did not work correctly for all window types
• Object fetch performance improved of Export Tables, Export User Objects and Compare User Objects
• Filenames for Compare User Objects difference viewer now include username and database
• New Plug-In versions released: VCS 1.0.7 and PL/Formatter 1.0.3.

Bugfixes and enhancements

• Project concept added
• Reports added
• Export User Objects tool added
• Compare User Objects tool added
• Export popup menu item added for all grids (CSV, TSV, HTML & XML format)
• Export Plug-In functions added + RTF export demo Plug-In
• SQL Window improvements:
  • Single Record View added
  • Export Query function added (CSV, TSV, HTML & XML format)
  • Collection columns can be viewed
  • Support for substitution variables added
  • Support for Oracle9i XMLTYPE added
  • Linked Queries function added
• Test Window improvements
  • HTP Output will be displayed on HTP Output tab page
  • PL/SQL Trace support added for Oracle8i and later
  • ‘Go to unit line’ popup item added to Profiler Report grid
  • Can now be saved in SQL*Plus format
  • Test Script generation now determines named record types and PL/SQL Table types
• Command Window improvements
  • SHOW ERR*ORS [ObjectType ObjectName] command added
  • SQLPLUS command added
  • SET NUM*WIDTH added to set the maximum width of numeric columns (default 10)
  • Executes login.sql when started
• Code Assistant improvements
  • Context description added (object names & keywords)
  • Is now resizable
  • Does no longer pop up when typing comments or strings
  • Immediately completes name when started manually and only 1 option is available
  • Can be started manually for partly typed sub-object (e.g. dbms_output.pu|)
• Table definition editor improvements
  • Support for index organized tables added
  • Columns can now be dropped from an existing table (Oracle8i and later)
• Object Browser improvements
  • Drop item added to table column popup menu (Oracle8i and later)
  • Profiles folder added
  • Job folder added + Run item added for job popup menu
  • Database links folder added
  • Now allows you to select multiple objects
  • Drag and drop object popup (Name, Description, Properties, DDL, Call, Select, Insert, Update, Delete)
• Editor improvements
  • Column editing added (Cut, Copy, Paste, Delete, and Edit > Selection functions)
  • Tab and Shift-tab now indent and unindent
  • Syntax case highlighting improved during typing
  • Recall Statement function added
  • Oracle9i SQL and PL/SQL keywords added for syntax highlighting
• Profile definition editor added
• Job definition editor added
• Database link definition editor added
• XML Syntax Highlighting and XML validation added to Text Editor for CLOB’s and VARCHAR’s
• Oracle9i plan table columns added for Explain Plan Window
• Drag & Drop from Browser and Templates to Workspace
• Insert Template popup menu item
• New preferences:
  • Logoff with open transaction (Commit, Rollback, Ask)
  • Show complete file path in window titles
  • Appearance tab page
  • Database lists to always or never add debug info
  • SQL Window: Date & Number fields to_char
• Improved handling of ConnectAs logon option
• From User and To User options added to Import Tables function
• LogonHistory enhancements
  • More.. option with sort option
  • Display size preference to limit the number of displayed items
  • Reduce number of items (on startup) if History size was reduced
  • Display checkbox for active connection
• Tables and Primary/Unique Keys with referencing foreign keys can now be dropped after confirmation
• Size of all non-PL/SQL object editors are saved
• Save Layout now also works with maximized windows
• Command-line parameters added: NOSPLASH, NOLOGON, NOPLUGINS

 Bugfixes and enhancements

• Connect as sysdba/sysoper did not propagate to secondary sessions. Therefore you could not connect as SYS when init parameter O7_DICTIONARY_ACCESSIBILTY=FALSE. This is the default setting for Oracle9i.
• Oracle Import and export did not work correctly with imp73 and exp73 on Windows 9X
• Explain Plan did not work for externally identified users
• Fixed installer “can’t create…” problem
• Force OCI7 on OCI8 preference did not hide”Connect As” option in Logon Dialog
• Command Window did not spool dbms_output results

Bugfixes and enhancements

• Generating a test script for program units with non-scalar parameters would not include a declare
• Picking a connection from a logon history without password and canceling would lead to an inconsistent situation
• Pressing the Parse button in Query Builder for an empty query would cause an Access Violation
• Removed Read Only option from Open File Dialog in Query Builder
• Fixed “Index out of Bounds” when deleting selected Browser Filter
• Enhanced Plug-In interface (IDE_Perform and OnMainMenu)
• Fixed “List index out of bounds (0)” during editing with Code Contents
• Browser Preference “Confirm Recompile” added
• Session Queries optimized: execution delayed until page is displayed
• Paste did not work in result grid of SQL Window in QBE Mode
• Reload in Program Window could lead to access violation
• In multi-session mode, NLS_DATE_FORMAT would be DD-MON-YY on some systems
• Escape possibility ($$) added for templat variables (e.g. $$DATE => $DATE)
• Adding a table from an other owner did not work correctly in Query Builder
• Result set in SQL Window was read only if multiple SQL statements were present in the editor
• Statements were not correctly separated in SQL Window if it ended with ); e.g. in (1,2);
• Add debug information for package and type specification now implicitly adds it to body
• Default file extensions were not applied in import / export functions
• Fixed problem with Plug-In function IDE_GetBrowserItems()
• Command Window could hang during execution
• Program Window title was not always kept up-to-date
• Export function could give error message “File plsexp.log could not be opened”
• Memory usage optimized in Find Database Objects function
• Added Cursor Home & Cursor End buttons in Find Dialog
• Default templates are loaded from default directory when not found in user defined directory
• Fixed printing problem with wrong second pages on some printers
• Fixed problem with printing Explain Plan Window twice

New Features 

• New Tools
  • Import Tables
  • Export Tables
  • External Tools
  • Event Monitor
  • Sessions
  • Query Builder
• New object definition editors for
  • User
  • Role
  • Library
  • Directory
• Plan Window Enhancements
  • All plan table columns can be selected
  • Optimizer goal can be changed
  • You can step though the operations in order of execution
  • Object popup added for ‘Object name’ column
  • Plan table cleared after execution
• Browser Enhancements
  • Users now have an Objects folder
  • Tablespace and Cluster folders added
  • Recent objects folder added
  • Preferences page added (Folders, Maximum recent objects, Double-click action, Show datatypes)
  • Function, procedure and method parameters can be displayed
  • Attributes and columns of object types can be recursively expanded
  • Methods can be described
  • Methods can be tested
  • Libraries folder added
  • Directories folder added
  • Filter button added
  • Filters can now be user-specific, with a default filter for each user
• SQL Window enhancements:
  • Query By Example mode
  • Configurable shortcut keys for buttons
  • Result set supports object types
  • Result set supports nested cursors
  • Check for lock before updating or deleting a record
  • Window title generated from SQL text instead of ‘New’
  • Selected statement will be executed
• Test Window enhancements
  • PL/SQL Profiler added for Oracle8i and later
• Debugger enhancements
  • Collection element items can be displayed e.g.: Employees(index).Name
  • Collections of scalar datatype can be viewed
• Command Window enhancements
  • SET COLWIDTH added
  • SET SCAN added
  • Object commands added (RECOMPILE, VIEW, EDIT, PROPERTIES, QUERYDATA, EDITDATA, EXPORTDATA, TEST, and BROWSE)
• Program Window enhancements
  • Java source support added
  • PLS-00323 and PLS-00538 handled smarter
• Code Contents enhancements
  • Code Contents selection now keeps track of cursor position
  • Select item added to contents popup menu for functions and procedures
• Object definition editor enhancements
  • Now shows creation SQL if no modifications were made
  • SQL can be opened in Command Window
• Table definition editor enhancements
  • Object table support added
  • Temporary table support added
  • Column types left aligned in create table SQL
  • Object popup added for foreign key referencing table
• Code Assistant enhancements
  • Support for object type constructors
  • Support for object type variables
  • Support for object type columns
  • Support for standard collection methods (first, limit, …)
  • Support for collection element object types
  • Support for %rowtype variables
• Editor enhancements
  • Uppercase/Lowercase/InitCaps keyword syntax highlighting
  • Apply syntax case to editor selection
• Plug-In enhanced (see Plug-In documentation for details)
• HTML Help enhancements
  • “Stay On Top” preference added
  • Search-delay implemented
  • Find function added to Internal HTML Viewer
• Find Database Objects now supports all object types
• Oracle Home preference added
• Check added on first startup for multiple oracle homes, and automatically select a valid home
• Holding down the Control key during Logon prevents that the connection is saved in the logon history
• Configurable Toolbar buttons
• New disabled Button style (only 32k color or better)
• New Info button on About screen
• New and improved installation procedure

Bugfixes 

• Fixed “get_scalar: exception 10” and “backend error 1003” error messages in trace file during debugging
• Main window could become invisible as result of “Autosave Desktop” preference
• Internal HTML Viewer still required Internet Explorer (“Class not registered”)
• HTML Help did not use context when activated for the first time
• Hyperlink Navigation caused Access Violation when Code Contents was not used
• Fixed occasional “Control has no parent window” error messages

Bugfixes and enhancements 

• Added Oracle8i keywords for syntax highlighting
• HTML Help is now compatible with IE 5.5
• View/Edit for a view created by other user did not include column alias
• Fixed Code Assistant related hang-up in Program Window
• Fixed “List index” error when reloading a changed Program File with more than 2 programs
• Fixed “Control has no parent window” error in Table Definition Editor
• Fixed delayed effect of font color preference in Template List
• Improved ‘default extension’ behavior when saving files
• Fixed AV’s after an object has dropped with reference folders opened
• Improved printing of (Auto column size) grids
• Improved copy from grid when first cells are empty

New features 

• Added an internal HTML Viewer for users without Internet Explorer
• Added a ‘Use internal HTML viewer’ preference
• Debugger can now set and view private global variables (declared in package body)
• Plug-In interface IDE_SetFilename added to change filename
• Plug-In interface IDE_Splash added to hide Splash screen

Bugfixes

• Toolbar buttons were not up to date after creating a new view
• Command Window could sometimes lock up when using commas in some commands
• Plug-In function IDE_RefreshMenus did not keep ShortCut keys active
• Fixed problems when connected as externally identified user (e.g. explain plan)
• Select statements could sometimes lock up Command Window on Windows 2000
• Fetching next page in SQL Window with modified results could result in ‘ghost records’
• Large Cost & Cardinality values could lead overflow error in Plan Window
• If a table and trigger had the same name, a describe would result in ORA-01422
• Corrected ‘Type’ and ‘Type body’ templates (no name after end)
• ErrorList in Program Window did not always show scrollbar
• Test Window debug button would get enabled in Single Session Mode after an error
• Test Window watches and callstack buttons were always enabled
• Code Assistant would not work for parameters after 10 lines
• Column defaults would sometimes be displayed with garbage characters

New features 

• Added a background color preference for Editor, Browser and Grids
• Added Date/Time dropdown in Test Window for date variables
• Delete word function made available as hotkey
• Added Confirm Commit & Rollback preference
• Added Commit on Post preference for committing posted records in SQL Window
• Holding down Ctrl while pressing the Post button will now implicitly Commit

Bugfixes

• Uppercase/lowercase or comment/uncomment affected readonly editors
• Long & Cursor variables didn’t get value cell in ‘Test’ function
• Precision and Scale were swapped in type attribute description
• Float columns were displayed with precision
• Alt-hotkeys in popup menus would cause a ‘beep’
• Quoted variable values in Command Window would include the quotes
• Tablename not recognized when right-clicking on “delete <tablename> where” statement
• Empty programs would lead to error message when compiling a Program Window
• View function for Tables, Sequences and Synonyms would always create a new window
• SQL error locations are now correctly displayed on Net8 8.0.5.
  (On 8.0.3 and 8.0.4 error locations are not reported)
• LOB variables could not be used in Test Window in Multi Session Mode
• VCS Plug-In did not work correctly with ComponentSoftware RCS

New features 

• Breakpoint conditions and messages
• Drag & Drop capabilities from Description/Properties Window to Editor
• Popup menu in editor margin with Bookmark and Breakpoint function
• Comment and Uncomment functions in Edit > Selection menu
• Comment text feature for templates
• Added (more…) to status line when more records are available in a SQL Window
• Next & Last Page items in Grid popup menu in a SQL Window
• Move, Insert & Delete variables in a Test Window
• Store Window List Short Text preference during Save Layout
• Align Grid item in Editor popup menu in a SQL Window
• Several Plug-In interface enhancement for the new Version Control Plug-In

 Bugfixes

• Grid printing would fail after first page on some printers
• Set Breakpoint menu item would set Bookmark instead
• Access violation with popup menu on empty editable result grid
• Userid parameter did not work
• Selection would grow when case-changing selection with multiple lines
• Fixed some template issues
• Trailing ‘/’ would sometimes unnecessarily be removed from a template
• Query results in a descriptive list in a template did not work properly
• Template could not handle * for default values in checkboxes
• Feedback limit would affect Insert, Update & Delete in a Command Window
• Default extension for @ command did not work properly in a Command Window
• Fixed some copy & paste issues in grids
• Next Page & Last Page in SQL Window did not work in single session mode
• Table editor could not handle indexes with the same name as a foreign key
• Optimized save function to store CSV file in SQL and Test Window
• Text in grids would ignore character set of selected grid font
• Width for numeric column formats in Command Window was not correct
• Test Window could not be closed if session was killed

New features 

• Code Navigation through Code Contents, Hyperlink Navigation and Browse back / forward buttons.
• New hierarchical Template Window with more powerful template format, the ability to insert template code into existing source code, and more.
• Create, drop, view, edit, and rename any object from within PL/SQL Developer, including tables, constraints, indexes, privileges, sequences and synonyms.
• A new Window List to easily navigate between multiple document windows.
• Command Window now has a built-in script editor with appropriate syntax highlighting, supports bind and substitution variables, and supports many new commands. Error locations are highlighted.
• Test Window now supports Long, Long Raw, BLOB, CLOB, BFile and cursor variables, and also supports Long, Long Raw, BLOB, CLOB and BFile fields in the result grid.
• SQL Window can now incrementally fetch results. Rows in the result grid can be locally sorted. Numbers are automatically formatted.
• Object Browser can now recursively expand objects. Triggers and constraints can be enabled and disabled. Drag and drop object names into editors.
• Code Assistant can now recognize table aliases for select, update and delete statements, can describe users and synonyms, and can be activated manually.
• Context sensitive object popups: only items appropriate for an object will be displayed (e.g. “Query data” for a table or view).
• Logon history with or without password can be maintained for easy logon.
• Editor syntax highlighting improved, new “Find matching pair” function, bookmark improvements, mouse wheel navigation improved.
• And much, much, more…

Bugfixes and enhancements 

• Separate print buttons in the toolbar for portrait and landscape
• Black/White printing preference added
• Fixed problem with missing line between printed pages
• You can now also print the output page of a SQL Window or Test Window
• Added print option to description & properties window
• The result grid in the SQL Window now resizes when the window is resized
• The SQL Window now also stores statements in the history buffer that are not yet executed
• Cut, Copy & Paste keys did not work in the Text Editor for Long columns in the SQL Window
• Fixed problems with comments and empty lines between ‘create or replace’ and the object type and name in the Program Editor
• Role granted to users displayed role granted roles in the Object Browser
• Commands in the Command Window were not recognized if followed by a tab character
• Command Window did not update the break, commit and rollback button after executing a pasted command
• Debug functions are now disabled in single session mode
• Main Window could sometimes disappear on Windows NT with ‘Autosave Desktop’ preference
• The ‘Wrap lines’ preference has been disabled, which caused problems with debugging and compilation errors
• Integration with our Direct Oracle Access components for Delphi and C++Builder
• Added results to TestWindow for Direct Oracle Access integration
• Oracle_Home would not be detected if the Home directory is not in the PATH
• SQL*Net in incomplete Multiple Oracle Home could not be initialized
• Some Plug-In enhancements

Bugfixes and enhancements

• Oracle8i related enhancements
  • Support added for Net8 8.1
  • Support added for Multiple Oracle Homes and the Oracle Home Selector
  • The parse error position, which is missing in Net8 8.0, is now supported for Net8 8.1
• Debugger related enhancements
  • You can now view and set public global package variables on 8.0.5 and later
  • The call stack now displays the program unit name for each frame on 7.3.4.3 or 8.0.5 and later
  • Double-clicking on a call stack frame now navigates to the source line on 7.3.4.3 or 8.0.5 and later
  • Cursor status (rowcount, open, found, notfound, …) displayed in variable value pop-up
• Other enhancements
  • Selecting ‘Test’ in the Object Browser for overloaded program units now allows you to select a specific overloading
  • The ‘Edit’ menu option in the Object Browser is now enabled for updateable views
  • In the Object Browser you can now view the triggers defined on a view
• Bugfixes
  • The icons in the Object Browser were invisible on systems with an older version of comctl32.dll
  • Newly recorded macros could only be assigned to a hotkey after restarting PL/SQL Developer
  • When the package state was discarded during a debug session, the debugger would sometimes crash
  • The debugger variable value pop-ups would sometimes “stick” on the screen

Bugfixes 

• Occasionally a Program Window would become extremely long after opening a file
• Access Violation when closing a maximized Test Window
• Ctrl- or Alt-key combinations could not be assigned to a macro
• Scan button in Test Window would find variables in quoted strings
• A new Code Assistant Style preference is provided, which controls how the Code Assistant inserts identifiers into the source code: Init Caps, Lowercase, Uppercase or Smart (default).

New features 

• Integration with Oracle HTML manuals
• User-defined shortcut keys for all functions
• Users, Roles, Synonyms and Object privileges added to Browser
• Refresh button in Browser now only refreshes the selected object
• Save Desktop preference added
• Explain plan is now displayed as a tree with descriptions in the status line
• New Directories preference added
• New editor preference: allow cursor after EOL
• Print selection added
• File association dialog for confirmation & manual selection
• Plug-In interface implemented (Documentation available on request)
• Several 2.0 bugfixes and improvements

New features 

• Multi threading / Multi session environment
• Oracle8 feature support (Types, CLOB’s, BLOB’s, BFILE’s)
• Integrated Debugger
• Template Library
• Browser Filters
• Command Window
• Compile Invalid Objects function
• Find Database Objects function
• Code Assistant
• Macro Library
• Many Editor improvements
• Many Browser improvements
• Many new preferences
• And much, much, more…