Oracle SQL Developer 1.5.5: Bugs Fixed

Oracle SQL Developer 1.5.5: Bugs Fixed

Date: July 2009

Bugs Fixed since Oracle SQL Developer 1.5.1 was released in June 2008.

Oracle SQL Developer 1.5.5 is scheduled for inclusion in Oracle Database 11gR2. It has a few code fixes on top of those added in release 1.5.3 and 1.5.4. This list of bugs fixed is a combination of fixes in 1.5.3, 1.5.4 and 1.5.5 and is not all-inclusive. For the list of bugs fixed between SQL Developer 1.5.0 and SQL Developer 1.5.1, please see the SQL Developer 1.5 Bugs Fixed list.

This list includes a selection of:

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

Bugs Fixed List

General

Reported as fixed for 1.5.3
- 7355899: Performance issues on opening tables nodes
- 6877752: Clicking find tools in external tools displaying registry exception
- 7243750: Drop table purge
- 6828106: Functions not displaying return type
- 7243714: Navigator: indicate public/private programs in package body
- 7243766: Performance monitoring
- 5162861: Persist last directory for all os interactions
- 5165109: Tree menu not in sync when doing 'find' in a package
- 7243755: Sort connections & create groupings
- 6802528: Cannot handle identifiers that begin with a dollar sign
- 7261683: Apex import fails for special characters
Additional 1.5.4 Fixes
- 7355899 Bad performance opening tables nodes
- 7695380 Database diff > lower-cased column name > don't have double quote in diff result
- 7695302 Database diff can not diff the table comment.
- 7677735 Diff wizard > diff lower case table - miss double quote in result
- 7025674 Hangs when working with CLOB columns
- 7592162 Hostname is half displayed in the new/select database connection dialog box.
- 7162048 Import data wizard prompts loading table 3 times after clicking cancel
- 7717260 NLS: Manage db option fails on NLS parameter change
- 8267971 Query breaks export
- 7592100 SQL History displays only types of scripts and not SQL
- 7555808 Exception displayed in the console when starting SQL Developer in win64 platform
Additional 1.5.5 Fixes
- 8340815 Manage database shutdown fail
- 7408923 Triggers of "other users" not visible using "triggers" tab
- 8392312 Object table in table node not visible
- 8460963 Slow other users node performance
- Long queries such as select count(1) from dual connect by level < 50000000 were re executed before export dialog appeared
- Edit BLOB Dialog text appears twice
- 8398748 SQL Developer 1.5.4 will not make a nullable field null
- SQL Developer 1.5.4: Slow to expand tables node for a oracle 9 connection
- 5637708 Sticky worksheet window size

Browser
- Reported as fixed for 1.5.3
  - 7246678: Add the ability to refresh a materialized view
  - 5214770: Included alphabetical ordering of functions / procedure in package
  - 7243076: Include alphabetical ordering of functions / procedure in package
  - 7310936: View does not show other users columns
  - 7151518: Grant > privileges - loading dialog box flashes 3 times after being cancelled
- Additional 1.5.4 Fixes
  - 7261683 APEX import fails for special characters
  - 7512507 Can't browse materialized view under other users connection
  - 8279405 Can't see the synonym for materialized view in list
  - 8249391 Popup describe : schema names are case sensitive
  - 7700449 Slow loading for the views metadata from objects browser
  - 7666178 Triggers not displayed for other users
- Additional 1.5.5 Fixes
  - 8399343 Drag and drop from "other users"-tables doesn't prefix with schema name.
  - 8362084 Garbage in detail log when import APEX application
  - 7154212 Garbled multi byte words in app/page names after imported
  - 6627395 Multi byte words in import dialog app are garbled
Connections

Reported as fixed for 1.5.3
- 6945271: Connection drop lists are sorted, but not case insensitive sort
- 7206476: Disconnect after creating & browsing PL/SQL objects- shows exception
- 6836296: MAC: new connection dialog too small for connect button
- 5362733: Network alias not populated from "tnsnames.ora" in Citrix environment
- 7044022: Not using tns_admin or ldap_admin to find ldap.ora
- 7044273: Wildcard used when searching for .ora files
- 7387779: Proxy user objects are not listed in connection navigator
Additional 1.5.4 Fixes
- 7704342 Auto connect on connection selection drop list in worksheet
- 6837457 Changing connection on worksheet does not change title bar
- 7602362 Connection type as TNS, network alias will show same the TNS name several times
- 8273675 LDAP connection fail while using OCI driver
- 7044022 Not using tns_admin or ldap_admin to find ldap.ora
- 7600304 On upgrade, some connection types are changed
- 8265022 Prompted for password on run/debug with unsaved password
- 8253136 Proxy connection info is not editable
- 6774587 Security: advanced connections aren't encrypted
- 7704324 Use keys to select item in connection selection
Additional 1.5.5 Fixes
- 8460869 ora-01017 when resetting a non-expired password
- 8360294 LDAP context not visible when server is correct
- 7608974 LDAP server string gives index out of range when sslport not given

Create and Modify

Reported as fixed for 1.5.3
- 6817124: Import data : unable to import date using XLS
- 7440901: Error thrown when adding to folder->new folder selected for a db connection
- 7031876: Single row sub query returns more than one row - view breaks and no data shows
Additional 1.5.4 Fixes
- 7112791 APEX: currency symbols incorrectly imported
- 7306357 Can't recreate same xml schema after running dbms_xmlschema.deleteschema
- 6995794 Copy wizard: create procedure containing & not handled
- 7038924 Create unique index on table fails and drops table
- 7674108 Dragging table into worksheet form other user; schema not included
- 6847255 MAC: copy starts, doesn't end, error goes to java stack
- 7031876 Single row sub query returns more than one row - view breaks and no data shows

SQL Worksheet
- Reported as fixed for 1.5.3
  - 7132408: Import data wizard - could not run script in worksheet
  - 7481915: Refactor: display compile errors in worksheet
  - 6282052: Select with joins causes SQL Developer to loop
  - 7478137: Separator: german group separator
- Additional 1.5.4 Fixes
  - 7036740 Closing unshared worksheet prompts for save twice
  - 7828714 Code insight gives errors on typing rowid in worksheet
  - 7534902 Database copy hangs while copying data large tables.
  - 7265163 Deadlock on pressing the execute statement button
  - 7700139 Describe (shift f4) only works for your own tables not schema.table
  - 6848224 Describe f4 fails on users tables on 9i db, and some v$ objects
  - 7666638 Invalid data in table data display
  - 7040155 Keyboard accelerators needed for SQL history
  - 7599313 NLS: garbled multi byte message in script output
  - 6968076 Pause statement not working
  - 7655884 Schema diff says constraints are differences when they are not
  - 7481193 Spool command in worksheet does not write results to the file
  - 7540998 SQL Worksheet not appearing when '#' in the windows username
  - 8239038 Start or @ file.sql does not check last opened directory/file.sql
  - 8279269 Unable to run a script file with @@ calling other files
  - 7037434 Unshared worksheet launch prompts inconsistently for password
- Additional 1.5.5 Fixes
  - 8417574 Password is clear text when using connect command
Data

Reported as fixed for 1.5.3
- 7203623: Date and timestamp columns are not showing up in SQL dev 1.5.1
- 6860918: Sorting on table with duplicate column names throws exceptions
Additional 1.5.4 Fixes
- 7132326 Can not display data with single quote in it
- 7515681 Can't browse data in BFile edit panel
- 7240969 Data tab's filter is not persisted
- 7712583 Error entering a null value in a number column
- 7344539 Error when sorting columns that require double quotes
- 7421863 Viewing data of olap_table view gives "rowid": invalid identifier error
Additional 1.5.5 Fixes
- 8288664 Failed to generate SQL for APEX with multi byte data

PL/SQL

Reported as fixed for 1.5.3
- 7463068 probe debugging does not work
- 7389123: Collapse icons don't show
- 7172737: Exception after opening PL/SQL editor and then disconnecting the connection
- 7374927: Long lines in PL/SQL source are broken on 4000 char boundary
- 7389109: Some code templates don't work
Additional 1.5.4 Fixes
- 8250324 VISTA: Debugger host for database debugging proposes IP address 0.0.0.0 for vista
- 7389109 Code template #user# don't work in PL/SQL editor
Additional 1.5.5 Fixes
- 8319015 code template is not working in opened SQL file

Preferences
- Reported as fixed for 1.5.3
  - 6956545: PL/SQL compiler options: incorrect syntax near the keyword alter
  - 7279723: Preference -> migration
  - 7140108: Inappropriate spacing on certain options: = > instead of =>
- Additional 1.5.4 Fixes

7148222 some formatter options cause replace and procedure name to be concatenated

Migrations and Third Party
- Reported as fixed for 1.5.3
- Additional 1.5.4 Fixes
  - 2257699 Calling a procedure using a variable to hold the procedure name
  - 8258458 Click cancel when associating repository will removes all package with md_%
  - 6844341 Duplicate column name error reported on translated ms access query
  - 2141159 Map removes closing " on view name with spaces
  - 2638876 More than one access built-in-function as default can't be parsed
  - 7155159 MySQL> offline datamove - run oracle_ctl got table does not exist error
  - 7605467 MySQL migration:bit[n] date type missed in set data map dialog
  - 6945225 No context menu to rename third party connections
  - 7626613 No drop option for trigger and sequence in captured and converted model
  - 7831232 nvarchar(max) captured as nvarchar(0)
  - 6082599 Quick migrate - does not check privileges granted via a role
  - 7013320 Remove migration repository also removes all user objects with md_%
  - 8261477 Run the generated DDL script throws error for cross referenced tables
  - 3375453 Solution needed for "a column may not be out-joined to a subquery"
  - 8230250 Sybase 15 index detail '<column name> desc' not handled
  - 915713 Sybase cursor directly mapped when simple assignment is required.
  - 7605486 Sybase migration: missing data type in set data map dialog
  - 1902272 Sybase:precedence problems with % which becomes mod() in PL/SQL
  - 7635749 Sybase:primary key will not be captured if capture single table with foreign key
  - 6853258 Table name is prefixed with some numbers when dropping it from captured model
  - 3377663 Temporary tables defined using local variables fail to generate
  - 2696196 t-SQL parser inserts extraneous table name prefix in 'for update of' clause
  - 7696219 user defined types basetype often longsysname instead of varchar2
- Additional 1.5.5 Fixes
  - 8245693 SQL Server: Data move fails for multi byte database name
Import and Export

Reported as fixed for 1.5.3
- 7442419: Export problem with ( . )
- 7265123: Not able to import data containing character such as quotes (''') and comma (,)
- 7287259: Result panel> export data - throws ora00904 error
- 7154185: Data import wizard, cannot proceed beyond step 1 of 4
- 7136086: Import data from XLS hangs
Additional 1.5.4 Fixes
- 8286026 Database copy wizard throws errors when table/column name is in mixed case
- 7322676 Dots are used as value separator when doing insert export
- 7304338 Error in the console during import data for tables
- 7706547 Error on export is attempted with simple alias
- 7524946 Error when export includes dependent objects
- 7835138 Export data is reordering columns in alphabetical order
- 7577549 Export DDL fails for some applications in SQL Developer
- 7644208 Export to txt in 'query result', the order of column and output are inconsistent
- 8278585 Header row with empty or formula cells causes import to fail
- 7700152 Import fails on a very wide and large XLS
- 7607194 Import from CVS -Changing first data type changes all data types
- 7197687 Import from XLS fails ...
- 8249063 Import varchar data will fail because it automatically add a comma
- 7656527 Table > export data: lower case letter in column names are not preserved
- 7656516 Table > export data: lower case table name fails
- 8197735 Wrong data imported from excel
Additional 1.5.5 Fixes
- 8414060 Import varchar data will fail because it automatically change 10 to 10.0
- 8365581 Preview table columns unreadable when importing wide xls
- 8349177 Import table creation fails to take default mapping
- 8345477 Can not reorder the selected column in page 2 of the wizard
- 8345462 Export fails with ora-00936 - missing expression
- 8341599 Column selection order not preserved in import wizard
- 8284966 Failed to export an APEX page with multi byte title
- 8278107 Multi byte words are garbled when export ddl to worksheet
- 7654436 Export to csv: delimiter is lost
- 7557372 Export data to csv changes column order to alphabetical
- 7431760 Extra column in file when export table data to insert
- 7658962 Duplicate columns on data import
- 8278585 Header row with empty or formula cells causes import to fail

Reports
- Reported as fixed for 1.5.3
  - 7271134: Add ash row source report
  - 7327107: Add encrypted table spaces to report in SQL Developer
  - 7271163: Add more reports for monitoring the database
- Additional 1.5.4 Fixes
  - 7022690 Legend in charts no longer readable - x-axis value is now vertical
  - 7557649 Manage data report needs to be closed before it can be run for a new connection
  - 7559629 Order by date error in "daily ash statistics chart"