Oracle SQL Developer 2.1: Bugs Fixed

Date: December 2009

Bugs Fixed since Oracle SQL Developer 1.5.5 was released in July 2009.

Oracle SQL Developer 2.1 is the latest release of SQL Developer, incorporating two significant additions to the product functionality and expansion to existing features. For a full list of new functionality see the SQL Developer 2.1 New Features list. The list of bugs shown below is not a complete list of issues addressed.

The list below is a selection of:

  • Higher priority bugs
  • Customer bugs reported using Metalink
  • Issues reported by the community on the forum

Bugs Fixed List

  • General
    • 8964952: sqldeveloper.exe does not run on 64 - bit windows (There is now a separate download for 64-bit platforms)
    • 7658435: SQL Code templates don't have a shortcut defined (There is no longer a key sequence for Code templates. Start typing the code and the code is displayed in the code insight dropdown list.
    • 6405929: Users inadvertently close tabs. close icon or button on tabs requested
    • 7115132 : Configure file type associations dialog appears on startup every time
    • 9063158 : Deadlock when closing table
    • 8968873 : MAC OS Exception trying to exit with cmd-q
    • 9182133 : Data tab fails to open for table column with hyphen
  • Browser
    • 7570656 : Can not browse the XMLType table in Oracle 9i database when created in SQL worksheet
    • 8971454 : Diff editor node file type not internationalized
  • Connections
    • 8910781 : Kerberos: krb5.conf is not necessary when credential file is configured
    • 8513891 : OS authentication is not working in Oracle 9i database
    • 8967543 : Alter session set plsql_optimize_level=0 fails in Oracle Database 9.2.0.6
    • 8742224 : Proxy_user[proxy_client]/proxy_user_password - no tables visible
    • 9023623 : Unable to disable/remove the 'save password' option in the database connection
  • Create and Modify
    • 9055172 : Application Express node is not displayed for Oracle XE database connection
    • 8712776 : Column order is wrong in SQL Loader and external table
    • 6810435 : Support for loading jar file
    • 6867742 : Users with permission select any dictionary cannot view trigger details
    • 7218227 : Views: SQL syntax is valid, query is invalid
  • SQL Worksheet
    The SQL Worksheet has been rewritten for SQL Developer 2.1
    • 7040479 : Auto format to upper, lower mixed case on keywords
    • 7033639 : Bind variable declared with variable command have case sensitive names
    • 9020337 : Canceling bind dialog when running query still runs the query
    • 8720323 : Cannot see privileges in other users
    • 9014862 : Query cancel does not work
    • 9065224 : Ctrl-enter for executing SQL is not working
    • 9000801 : Worksheet launcher does not remember the last/default connection
    • 9008744 : Set role not working anymore
    • 8983720 : Worksheet result window resizes to default each time run statement occurs
    • 8968832 : Autotrace and explain plan loose focus after running
    • 8559991 : Inner/outer block scoping problems
    • 9015013 : Substitution variables not persistent between f5 and f9 runs
    • 9164619 : Add connection name to query results tab
    • 9164622 : Worksheet grid auto-reconnecting a closed connection
    • 8640482 : Select sdo_gcdr.geocode(..) from dual fails.
    • 8473666 : Set feedback,termout off is of no use in SQL worksheet
    • 8318927 : Set pause on' is skipped by SQL Developer
    • 6438974 : SQL Array fetch size parameter not applied throughout
  • Data
    • 9045220 : Rollback in data grid not working when post-on-row-change is on
    • 9104616 : Time part of date/timestamp not shown in the grid
    • 6993776 : In timestamp columns changes in the time and changes in am/pm not persisted
    • 8969021 : Data grid cannot select all data (ctrl-a)
    • 9181885 : XMLType renderer should not fetch the full XML
    • 6964633 : Time fields in date popup editor don't hold the seconds part of the date
    • 7004330 : Update date in data grid, resets time details for date format without timestamp
  • PL/SQL
    • 7463068 : Probe debugging does not work
    • 8586272 : Remote debug changes from 'listen for jpda' to 'attach to jpda',can't connect
    • 8898158 : Smart data tab is not working -- nothing displayed
    • 8937509 : %type not supported in PL/SQL
    • 9055004 : Trigger line numbers incorrect
    • 8514280 : Error (pls-00753 ) compiling valid wrapped package body
    • 9002825 : PL/SQL debug variable popup
    • 8936948 : LOB not supported with PL/SQL type with procedure/function parameters
  • Migrations and Third Party
    • 9135613 : Can't create SQL Server conn using null password
    • 8434381 : No date is displayed in date editor for third party date time
    • 7256785 : SQL Server 2000 browse data (and data grid) do not display datetime values
    • 9037545 : Migration estimation tool missing
    • 6958291 : Not equals ! = with a space between the bang and equals is not recognized
    • 9018019 : Set data mapping doesn't work in captured models panel
    • 9056076 : Failed to convert single schema
    • 9048510 : Generated trigger for auto increment type contains infinite loop
    • 7439146 : MySQL quick migration stopped in convert step
    • 9048353 : Access migration:generated trigger for auto number contains an infinite loop
    • 9049229 : Access offline data move:numbers loosing negative sign for currency type
    • 9022728 : Access table name('privileges') conflict with Oracle reserved words
    • 8919285 : Capture single table with FK, no captured model will come up
    • 9117186 : Default repository in preference not reflected in quick migration wizard
    • 9112289 : Failed to capture single table if table name contains dollar sign($)
    • 8537114 : Invalid index name in generated DDL
    • 9075652 : objects' name conflict with Oracle reserved words
    • 8829558 : User name and pwd changed to lower case when edit generated DDL
    • 8545303 : After quick migrate, the database name in captured model has unneeded $ in name
  • Import and Export
    • 9088053 : Can't import data from excel while column type is number
    • 8624834 : Column reordering in grid is not maintained in exported format
    • 8737494 : Database copy needs "set define off" option
    • 8316794 : Database export does correctly export date values
    • 7004898 : Does not export spatial data correctly: spatial point objects cannot be exported
    • 6836751 : Export wizard, export to file large table 300000, or many objects fails
    • 9170472 : Excel export of large query has missing records and is slow
    • 8867125 : Export BFile data to SQL insert statements should include explicit references
    • 8904540 : Export BLOB, CLOB to SQL insert statements should include explicit references
    • 8624599 : Export to fixed format fails from data tab
    • 8346007 : Export to text or csv wraps numbers (all data) in quotes
    • 8933791 : Export fails when table has column names that are Oracle reserved words
    • 8941824 : Importing large XLS results has out of memory error
    • 9182502 : Fixed formatter doesn't export null columns correctly
    • 8941827 : Import data fails for multiple sheet in XLS
    • 9016694 : Import data - check (header) column names when header is selected
    • 9016703 : Import data - precision set to 0 when all rows have null value for column
    • 8767845 : Import data default column names inconsistent with create table
    • 8746036 : Import data does not generate for SQL mode when cols omitted at end of row
    • 8764089 : Import data from csv file without a header does not generate SQL
    • 8817631 : Import data from XLS file should not allow external table or SQL Loader
    • 9016662 : Import data precision set incorrectly for numeric fields
    • 8763749 : Import data with csv file does not always determine correct number of fields
    • 8562499 : Fail to import from excel or csv with calculated columns
    • 8765385 : Precision / scale getting changed when importing numeric data from file
    • 8841693 : Import data should not generate create table with quoted column names
    • 8771644 : Table import data should have column props on col definition panel disabled
    • 8777373 : Tables import data for csv file fails to insert all rows

  • Reports
    • 8971483 : reports "go to" option not working for packages