PL/SQL Developer - News

October 23, 2017 - Version 12.0.6 released
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
August 16, 2017 - Version 12.0.5 released
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
July 7, 2017 - Version 12.0.4 released
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
May 26, 2017 - Version 12.0.3 released
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
April 18, 2017 - Language packs for version 12.0 released
Language packs for Brazilian, Chinese, Hungarian, Japanese, Russian and Spanish have been released. French and German will follow shortly.
 
March 20, 2017 - Version 12.0.2 released
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.
February 14, 2017 - Version 12.0.1 released
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
February 7, 2017 - Version 12.0 released
For a description of the new features in version 12.0, visit the New Features page.
April 22, 2016 - Version 11.0.6 released
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
February 12, 2016 - Version 11.0.5 released
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
December 29, 2015 - PL/SQL Developer 11.0.4 64 bit released
The 64 bit version of PL/SQL Developer 11.0.4 has been released.
September 1, 2015 - Version 11.0.4 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
June 10, 2015 - Version 11.0.3 released
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
April 24, 2015 - Version 11.0.2 released
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
April 13, 2015 - Version 11.0.1 released
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$...)
March 3, 2015 - Version 11.0 released
For a description of the new features in version 11.0, visit the New Features page.
July 11, 2013 - Version 10.0.5 released
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
June 6, 2013 - Version 10.0.4 released
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
May 6, 2013 - Version 10.0.3 released
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
April 4, 2013 - Version 10.0.2 released
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
March 8, 2013 - Version 10.0.1 released
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
March 1, 2013 - Version 10.0 released
For a description of the new features in version 10.0, visit the New Features page.
March 22, 2012 - Russian language pack released
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.
 
March 12, 2012 - Version 9.0.6.1665 released
Enhancements
  • Fixed a resource leak introduced in 9.0.6.1661
  • Connection List logon dialog could be slow
February 24, 2012 - Version 9.0.6 released
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
January 24, 2012 - Version 9.0.5 released
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
December 20, 2011 - Version 9.0.4 released
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
November 24, 2011 - Version 9.0.3 released
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
October 13, 2011 - Version 9.0.2 released
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
September 5, 2011 - Version 9.0.1 released
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
July 19, 2011 - Version 9.0 released
For a description of the new features in version 9.0, visit the New Features page.
June 11, 2010 - Version 8.0.4 released
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
April 2, 2010 - Version 8.0.3 released
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
February 11, 2010 - Version 8.0.2 released
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
January 7, 2010 - Version 8.0.1.1502 released
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
January 5, 2010 - Version 8.0.1.1501 released
Hotfix for the following 8.0.1 issues
  • Code Assistant did not work anymore for subselects
  • Unpinned dockable tools did not always retract
December 14, 2009 - Version 8.0.1 released
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
September 26, 2009 - Version 8.0 released
For a description of the new features in version 8.0, visit the New Features page.
May 26, 2008 - Version 7.1.5.1398 released
Hotfix for the following issue
  • Posting NVARCHAR2 unicode data in the SQL Window could lead to truncated results
April 18, 2008 - Version 7.1.5.1397 released
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
March 25, 2008 - Version 7.1.5 released
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
November 2, 2007 - Version 7.1.4 released
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
September 27, 2007 - Version 7.1.3 released
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
August 13, 2007 - Version 7.1.2 released
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
May 10, 2007 - Version 7.1.1 released
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
April 23, 2007 - Version 7.1 released
For a description of the new features in version 7.1, visit the New Features page.
September 22, 2006 - Version 7.0.3 released
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
May 15, 2006 - Version 7.0.2 released
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
March 1, 2006 - Version 7.0.1 released
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
January 23, 2006 - Version 7.0 released
For a description of the new features in version 7.0, visit the New Features page or download the New Features document (Acrobat Reader PDF format).
November 1, 2005 - Version 6.0.6.947 released
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
October 22, 2005 - Version 6.0.6.946 released
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
March 23, 2005 - Version 6.0.5.931 released
Enhancements
  • Add debug information menu option did not work if "add debug info when compiling" preference was disabled
March 14, 2005 - Version 6.0.5 released
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]
January 5, 2005 - Version 6.0.4 released
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
October 11, 2004 - Version 6.0.3 released
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
September 14, 2004 - Version 6.0.2 released
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
August 25, 2004 - Version 6.0.1 released
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
August 10, 2004 - Version 6.0.0 released
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
March 24, 2004 - Version 5.1.6 released
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
March 6, 2004 - Version 5.1.5 released
 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
November 6, 2003 - Version 5.1.4 released
 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
July 17, 2003 - Version 5.1.3 released
 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
April 29, 2003 - Version 5.1.2 released
 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
March 13, 2003 - Version 5.1.1 released
 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
January 27, 2003 - Version 5.1.0 released
 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
June 22, 2002 - Version 5.0.3 released
 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
April 8, 2002 - Version 5.0.2 released
 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()
January 5, 2002 - Version 5.0.1 released
 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.
December 10, 2001 - Version 5.0.0 released
 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
October 8, 2001 - Version 4.0.3 released
 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
July 16, 2001 - Version 4.0.2 released
 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
March 15, 2001 - Version 4.0.0 released
 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
October 14, 2000 - Version 3.0.5 released
 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
August 28, 2000 - Version 3.0.4 released
 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
June 26, 2000 - Version 3.0.3 released
 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
March 21, 2000 - Version 3.0.2 released
 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
February 7, 2000 - Version 3.0.1 released
 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
December 22, 1999 - Version 3.0 released
 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...
August 1999 - Version 2.1.3 released
 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
May 1999 - Version 2.1.2 released
 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
March 1999 - Version 2.1.1 released
 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).
February 1999 - Version 2.1 released
 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
November 1998 - Version 2.0 released
 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...