There was another thread related to this (
457310 ), but the suggestions in that thread did not work for me.
I am unable to use version 1.1 because I cannot see any packages, procedures or functions from the treeview. Clicking on the (+) next to these items results in an ORA-00942 error.
Oracle 10g (10.2.0.1.0)
SQL Developer 1.1 (1.1.0.23 build main 23.64)
Windows XP
I believe my user is the schema owner, and qwerying session_privs returns:
PRIVILEGE
----------------------------------------
CREATE SESSION
UNLIMITED TABLESPACE
CREATE TABLE
SELECT ANY TABLE
CREATE CLUSTER
CREATE SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE DATABASE LINK
CREATE PROCEDURE
CREATE TRIGGER
CREATE TYPE
CREATE OPERATOR
CREATE INDEXTYPE
RESUMABLE
When trying to follow some of the suggestions regarding granting to the DBA_OBJECTS or DBA_SOURCE to public I get the same error, even though I am able to DESCRIBE these objects and can execute the procedures in the packages.
When clicking on the proc, pack, func nodes under the Other Users node I get the same error.
I would really like to move to 1.1, so any suggestions are appreciated.