Sqldeveloper Will not show stored procedures
525194Aug 2 2009 — edited Aug 4 2009Hi there.
I am developing on Oracle 11g hosted on Suse, and have written a series of procs, functions etc.
I can write and run these in SQLDEVELOPER no problems, however when i attempt to expand the tree in the connection view for any of the following:
[+]Views
[+]Indexes
[+]Packages
[+]Procedures
[+]Functions
[+]Triggers
[+]Java
I get: ORA-00904: "PURGE_OBJECT":invalid identifier.
When trying to expand the RECYCLEBIN I get the following issue:
ORA-00904: "TYPE":invalid identifier.
I am assuming that it is something to do with the recycle (purge_object is a view column based on purobj as far as i can tell), however; I can open as a DBA no problems.
anyone having/had this issue? Any work arounds or fixes?
I have tried granting ALL privileges to the user i am compiling as with no success.
Cheers