Bug Fixed since Oracle SQL Developer 1.1 Patch 2 was released on 1st March 2007

• General
  • Bug 5925904: PROBLEM WITH IDE EDITOR REFRESH DURING MOUSE SCROLL
  • Bug 5071359: CANNOT INVOKE SQL*PLUS ON WINDOWS 2003
  • Bug 5887879: SQL DEVELOPER HANGS WHILE LONG RUNNING QUERY AND EXPAND THE DB OBJECT BROWSER
  • Bug 5926084: MAX CURSORS BEING HIT, MANY TABLES SCROLLED, OR MANY TABS OPENED, WITH PL/SQL
  • Bug 5571672: EDIT > FIND : SEARCH LIMITED TO TEXT IN 1 LINE ONLY
  • Bug 5635077: EXTENSIONS FOR 1.0 NO LONGER WORK IN 1.1
  • Bug 5687914: PERFORMANCE ISSUES RELATED TO THE INDEX TAB
  • Bug 5713398: IMPORT DATA FROM EXCEL : NO COLUMN HEADING CAUSING NUMBER FORMAT EXCEPTION
  • Bug 5767913: DB OBJECT SEARCH : RECENT OBJECTS LISTS CANNOT BE MINIMISED
  • Bug 5857318: COMMENTED AMPERSAND IS ATTEMPTED TO BE USED AS A SUBSTITUTION VARIABLE
  • Bug 5943588: CONNECTION SELECTOR DIALOG SHOULD BE CONTEXT SENSITIVE OF SQL WORKSHEET
  • Bug 5079582: ADD PARAMETER TO REDIRECT PROFILE AWAY FROM JDEV.USER.HOME
  • Bug 5870852: SELECTION CONNECTION DIALOG PRESSING J CYCLES THE DROP LIST
  
  


• Browser
• Bug 5933978: GRANT PRIVILEGES TO PACKAGES DOES NOT ENABLE OTHERS USERS TO SEE BODIES
• Bug 5941049: ORA-942 WHEN BROWSING PROCEDURES, WHEN SELECT ANY TABLE IS GRANTED
• Bug 5875012: ORA - 00942 ERROR ON EXPANDING THE PACKAGES, PROCEDURES FUNCTIONS NODE
• Bug 5767843: MATERIALIZED VIEW DISPAYED UNDER TABLES - CANNOT BE DROPPED FROM THERE -ORA12083
• Bug 5871366: PACKAGE NODE REFRESH ERASES PACKAGE DETAILS
• Bug 5929466: READ ONLY USERS CANNOT VIEW TRIGGERS
• Bug 5112631: SQL DEVELOPER: "APPLY FILTER" DOESN'T ALWAYS WORK
• Bug 5635287: BROWSER EXCEPTION EXPANDING NON-ORACLE CONNECTIONS
• Bug 5875509: CURSOR LEAK IN OBJECT NAVIGATOR PANEL
• Bug 5933339: DB OBJECT SEARCH NOT OPENING PACKAGE BODIES AFTER THEY ARE FOUND
• Bug 5948976: PERFORMANCE: QUERYING SYNONYMS IN THE NAVIGATOR IS VERY SLOW
• Bug 5712467: XML SCHEMAS > BROWSE - NOTHING DISPLAYED
• Bug 5768614: NLS:WRONG DATE FORMAT FOR CHINESE IN TABLE BROWSER - DETAILS PANE
  


• Query Builder
• 5613347: QUERY BUILDER - WHERE CLAUSE IS WRONG.
• 5636438: SQLDEVELOPER1.1: NLS: UNEXPECT DATE FORMAT GENERATED BY QUERY BUILDER
• 5636505: SQLDEVELOPER1.1: NLS: UNEXPECT NUMBER SEPARATOR GENERATED BY QUERY BUILDER
• 5770446: USING QUERY BUILDER CAN'T SEE OTHER SCHEMA'S TABLES
  


• Create or Modify Objects
• Bug 5945240: NOT ABLE TO ADD PRIMARY KEY CONSTRAINT TO THE TABLE
• Bug 5749879: RENAME A CONNECTION > ENTER PASSWORD - HAVE TO CLICK CANCEL BUTTON TWICE TO EXIT
• Bug 5691311: PRIVILEGES CAN BE GRANTED BUT CANNOT BE REVOKED
• Bug 5944876: TABLE > COLUMN> COMMENT - COLUMN DROP LIST IS EMPTY.
• Bug 5944897: TABLE > STORAGE > MOVE TABLESPACE - DROP BOX IS EMPTY
• Bug 6019011: CREATE SYNONYM GIVING ORA -00933 ERROR
• Bug 6019100: DATABLE LINKS NODE NOT AVAILABLE IN THE CONNECTION NAVIGATOR
• Bug 6033872: CREATE PROCEDURE / FUNCTION / PACKAGE FAILING
• Bug 4948602: PROCEDURES > CREATE PROCEDURE - INCONSISTENCY WHEN VALIDATING PARAMETERS
• Bug 5845866: SCHEMA DIFF,IN RESULTS TAB LAST DISPLAYED RESULTS SHOWN WHEN NO OPTION SELECTED
• Bug 5860457: EDIT DATA IN INDEX ORGANIZED TABLE NEEDS A COMMIT AFTER EVERY ROW
• Bug 5945232: ALTER SEQUENCE CHANGES THE MINIMUM VALUE
  


• Preferences
  • Bug 5880106: TOOLS - PREFERENCES - EXTENSIONS, LIST IS EMPTY EVEN WITH NEW EXTENSIONS ADDED
  • Bug 5873018: TOOLS, PREFERENCES, CREATE NEW FOLDER DIALOG FAILS TO RENAME FOLDER
    


• Connections
  • Bug 5841124: SAVE PASSWORD OPTION UNCHECKED IN NEW/SELECT DATABASE CONN, STILL PWD DISPLAYED
  • Bug 5596854: CONNECTION - NEW CONNECTION USING CONNECT IDENTIFIER FAILED
  • Bug 5859670: REGRESSION: FROM 1.1, YOU CAN'T UPDATE, SAVE AND CONNECT AN EXISTING CONNECTION
  • Bug 6024944: SQL SERVER CONN. DISAPPEARS FROM NAVIGATOR AFTER RECONNECT
  • Bug 5716230: CANNOT LOGIN TO SQL SERVER WITH BLANK PASSWORD
    


• Data
  • Bug 5923476: ORA-00942 IN DATA TAB FOR ORDINARY USER AS SYSDBA
  • Bug 5574567: TABLE > DATA; CLOSING WITH PENDING CHANGE AND THEN REOPENING ASKS TO SAVE TWICE
    


• Export
  • Bug 5707730: SQLDEV1.1: NLS: MB CHARS ON EXCEL IMPORT INTO TABLE DIALOG ARE GARBAGE
  • Bug 5870014: REGRESSION FRM1.1 JAVA.IO.BUFFEREDOUTPUTSTREAM WHEN EXPRTING TO CLIPBOARD
  • Bug 5884618: EXPORT TO EXCEL ENCODING SWITCHING TO OTHER LANGUAGES ENCODING FAILS
  • Bug 5904174: EXPORT EXCEL IN DB OBJECT SEARCH FOR A TABLE DISPLAYING ERROR MESSAGE
  • Bug 5929407: IMPORT XLS FAILS BEFORE DIALOG INVOKED IF SPREADSHEET COLUMNS HAS RESERVED WORD
  • Bug 5968619: EXPORT DDL CREATES ZERO BYTE OUTPUT FILE
  • Bug 6026185: TOOLS > EXPORT DDL - ERRORS IF SELECT ALL OBJECT TYPES
  • Bug 5469516: EXPORT TO EXCEL HAS PROBLEM IF DECIMAL SEPARATOR IS COMMA.
  • Bug 5570127: DDL FILE CREATED ON EXPORT DOES NOT TAKE DEPENDENCY INTO ACCOUNT
  • Bug 5678829: SQL STATEMENT GENERATED IS NOT FINE WHEN 'TYPE' OBJECT CHOOSEN FROM OTHER USER
  • Bug 5692243: IMPORT FROM EXCEL FAILS
  • Bug 5749862: TOOLS > EXPORT > EXPORT FAILING WHEN TREE MINIMISED
  • Bug 5751816: IN EXPORT DATA, THE HEADINGS DOES NOT MATCH WITH THE DATA LISTED.
  • Bug 5759731: EXPORT DBLINKS RESULTS IN EMPTY FILE
  • Bug 5767964: TOOLS > EXPORT : OBJECT TAB , OBJECTS TREE ARBITARILY EXPANDING
  • Bug 5850300: EXPORT DDL - INCONSISTENCY WHEN EXPORTING ALL TABLES VS EXPORTING ONE TABLE.
  • Bug 5851290: EXPORT DDL: SHOW SCHEMA DOESN'T WORK
  • Bug 5851478: TOOLS > EXPORT DDL - STORAGE OPTION DOESN'T WORK
  • Bug 5851895: TOOLS > EXPORTS DDL - SOME OPTIONS ARE NOT WORK ON DB 11.1
  • Bug 5857186: NO WAY TO EXPORT ALL OBJECT FOR A SCHEMA AT SINGLE CLICK
  • Bug 5874427: IN EXPORT DATA, THE COLUMN IS EXPORTED WITH NULL VALUES.
  • Bug 5874592: EXPORT DDL DOES NOT EXPORT OTHER USER OBJECTS.
  • Bug 5912309: EXPORT REQUERIES TWICE BEFORE CREATING THE REPORT
  • Bug 5914798: TOOLS > EXPORT DDL > OBJECTS > ALL OBJECTS - "+" SIGN DOES NOT EXPAND CORRECTLY
  • Bug 5926200: REORDERING COLUMNS CAN PRODUCE INCORRECT EXPORT OUTPUT AND FAIL INSERT STATEMENT
  • Bug 5977817: AFTER AN ERROR IN SQL, THE EXPORT OPTION IS GONE FROM THE CONTEXT MENU
  • Bug 6007636: EXPORT DDL FAILS TO EXPORT IF TABLE AND INDEX HAVE SAME NAME
  • Bug 6026182: TOOLS > EXPORT DDL - DIALOG BOX UI MESS
  • Bug 6028874: TOOLS . EXPORT DDL : FILTER OBJECTS TAB. THE CONNECTION SLECT LIST HAS NO LABEL
    
  
  
• Reports
  • Bug 5711102: USER DEFINED DRILL DOWN REPORTS LOSE REPORT ID, SO FAIL TO BE SAVED
  • Bug 5841116: ERROR DISPLAYED WHEN CLICKING CANCEL IN CHOOSE FILE DIALOG WHILE EXPORTING
  • Bug 5860519: REPORT THAT CAUSED REPORT TREE VIEW TO NOT DISPLAY PROPERLY
  • Bug 5516657: USER DEFINED REPORTS->LOAD ANY FILE->VALIDATION FOR SQL TEXT AREA
    


• SQL Worksheet
• Bug 5033057: EXPLAIN PLAN NOT WORKING (COULD BE 9.2 ISSUE)
• Bug 5661283: CAN NOT OPEN SQL WORKSHEET WINDOW FOR A CONNECTION MADE
• Bug 5680025: FAILED TO RUN SQL WHICH IS GENERATED BY EXPORT DDL
• Bug 5874952: ALTER USER COMMAND IN SQL WORKSHEET RESULTING IN EXCEPTION ERROR
• Bug 6002582: ORDINARY USER CONNECTED AS SYSDBA : SELECT STATEMENT GIVING ORA 942 ERROR
• Bug 6035515: ROLLBACK NOT WORK AFTER STARTING OF SQLDEVELOPER
• Bug 5020908: DATA DICTIONARY REPORTS-WORKSHEET INTEGRATION THROWS SQL ERROR IN SCRIPT OUTPUT
• Bug 5200928: QUERY COLUMNS WITH LONG NUMBERS: UNABLE TO SEE ENTRY UNLESS CONVERT TO CHARACTER
• Bug 5201072: EXPLAIN PLAN VIA CURSOR SELECT FAILS INTERMITTENTLY
• Bug 5398412: EXECUTE SCRIPT TO STOP ON AN ERROR
• Bug 5739334: TIMESTAMP WITH LOCAL TIME ZONE COLUMN WERE NOT CONVERTED
• Bug 5841335: EXECUTE EXPLAIN PLAN & AUTOTRACE BUTTONS GREYED OUT SOMETIMES
• Bug 5844096: SQL*PLUS COMMAND SET ESCAPE REQUIRED, AMPERSAND & ALWAYS PROMTPS FOR BINDAR
• Bug 5855134: UNINTENTIONAL AMPERSAND IN DIALOG PROMPT FOR SQL WORKSHEET
• Bug 5859662: REGRESSION FROM 1.0: CONTROL SPACE DOES NOT WORK ON PARTIAL CODE INSIGHT
• Bug 5873923: SQL HISTORY LIST DIALOG BOX NOT DISPLAYED CLICKED FOR THE FIRST TIME
• Bug 5875301: COPYING QUERY RESULT SET INTO THE CLIPBOARD DOESN'T WORK
• Bug 5877823: NO SUPPORT FOR THE SQL *PLUS VARIABLE COMMAND
• Bug 5877826: NO SUPPORT FOR SQL*PLUS PRINT COMMAND IN SQL WORKSHEET
• Bug 5878115: MISSING SQL*PLUS COMMANDS, DEFINES, VERIFY, ACCEPT
• Bug 5884935: BINDS IN A PL/SQL STATEMENT HAS "NOT ALL VARIABLES BOUND" ERROR
• Bug 5921266: COLUMNS WITH SAME NAME IN QUERY CAUSE REORDER PROBLEM
• Bug 5922129: TAB FILENAME NOT UPDATED WITH SAVE AS OPERATION
• Bug 5922612: SQL WORKSHEET RESULTS NOT DISPLAYED CORRECTLY AFTER CONNECTION DISCONNECT
• Bug 5943735: SET AUTOPRINT ON/OFF NOT SUPPORTED.
• Bug 5873375: COMPLETION INSIGHT -- DOUBLECLICK ON A LIST ELEMENT DOESN'T DO ANYTHING.
• Bug 5884952: EDIT BUTTON IS ENABLED WITH NO CONNECTION
  


• Snippets
• Bug 5884656: EDIT SNIPPET DIALOG'S TABLE SHOULD BE EDITABLE



• PL/SQL
• Bug 5690300: ICONS:NEED TO BE MORE IDENTIFYABLE FOR PL/SQL CONSTRUCTS IN PACKAGES, PROCEDURE
• Bug 5859704: PLSQL-EDIT LOG SHOULD DISPLAY MORE THEN 20 ITEMS
• Bug 6035508: DEBUG FAILED FOR 9.2.0.8 DATABASE IF USING CONNECT IDENTIFIER
• Bug 5247919: DEBUG DEBUGGING FUNCTIONS WITH BLANK LINES CAUSES CONTROL POINTER TO GO ON BLANK LINES
• Bug 5849018: DEBUG CONNECTION > REMOTE DEBUG - MISS A CHECK ITEM FOR THE FIRST TIME
• Bug 5862511: COMPILE INVALID OBJECTS DOES NOT WORK.
  


• 8.1.7 Database Support
• Bug 5183337: BROWSER FOR ORACLE8, DISPLAY OF MATERIALIZED VIEWS



• Third Party Support
• Bug 5699320: THIRD PARTY CONNECTIONS: CANNOT EXPORT DATA
• Bug 5708743: DRAG AND DROP QUERY FOR MYSQL FAILS
• Bug 5708745: NO CONTEXT MENU FOR MYSQL NAVIGATOR TO INVOKE SQL WORKSHEET
• Bug 5851815: NEED TO BE ABLE TO SET AUTO COMMIT OPTIONS
• Bug 5904616: MYSQL : NO CONTEXT MENU FOR TABLES / INDEXES IN CONNECTION NAVIGATOR
• Bug 5904663: SQL SERVER : ERROR BROWSING FUNCTIONS / PROCEDURES
• Bug 5929223: SQLSERVER2K BROWSING OF TABLES DOES NOT GIVE THE TABLES FROM SELECTED DATABASE.
• Bug 5904648: SQL SERVER : DRAG & DROP TABLE ONTO SQL WORKSHEET PRODUCES INCORRECT QUERY
• Bug 6031597: CAN'T OPEN MS ACCESS CONNECTION IN NAVIGATOR