[faruque_nawaz]

Hi

How do I view the Packages , Procedures , Functions , db_links, etc.
stored in the database using myeclipse Database browser? I can see only Tables , Views and synonyms…thats all…whereas in other tools like TOAD and PL/SQL Developer these can be browsed very easily.

Regards
Nawaz
General Electric

[support-jeff]

For what RDBMS? These are all supported for Oracle already as of ME 3.8.3. Have you upgraded yet? If so, what version of Oracle are you using and are there any errors in the eclipse logs related to the com.genuitec.eclipse.sqlexplorer.oracle plugin? Is that plugin even showing up as active? Please post all the info asked for in the Forum Posting Guidelines, http://www.myeclipseide.com/PNphpBB2+file-viewtopic-t-393.html.

[faruque_nawaz]

hi

I m working in Oracle 9.2 and installed the latest version of ME.
I didnt get any kind of error and the installation was succesful. I can
view the packages and procedures using Oracle standard queries.
I would like to view the nodes of Packages , Procedures , Fuctions , etc
under “Connected to databse”….where we can browse through all of them
by clicking the mouse as we can do now in case of Tables , Synonyms and
Views only….hope I m able to make myself clear this time…

Regards
Faruque
General Electric

[support-jeff]

So it sounds as if you are seeing the nodes for PROCEDURES, FUNCTIONS, etc. in the DB Browser, but there are no nodes under these “headers”, is that correct? In which case, are you sure you are connected as a user and viewing a schema that has these? When you set up your connection profile, did you select to view all schema, default schema, or did you select a subset?

[faruque_nawaz]

hi

No , I am not able to see even the headers for these in the DB
browser…I am connected as a user and the schema has got enough
procedures , functions , packages and other database objects . In case
I open the schema using other tools , I can very well browse through
each one of them. Even in the documents of ME , I can find only
Tables , Synonyms and Views are mentioned. Is that only what ME
supports or is it possible to view all the database objects using ME
database explorer?

Regards
Nawaz
General Electric

[vdbdavid]

I have the same problem (see thread https://www.genuitec.com/forums/topic/pl-sql-editor-with-cvs-integration/&highlight= )

[support-jeff]

Nawaz –

Again, these are Oracle-specific features in ME. The documentation for the new Oracle plugin is not available at this time, so you only see the plain old, vanilla DB Explorer docs.

Please make sure there are no errors in the error logs related to the sqlexplorer packages: check in {WORKSPACE}/.metadata/.log.

Please confirm that the user you log in as has privileges to access PL/SQL, packages, etc. Specifically, the user must have select privileges on sys.ALL_OBJECTS, sys.ALL_SOURCE, and sys.ALL_DEPENDENTS tables.

Please confirm that the schema you selected to browse is the OWNER of the objects you expect should be there (according to the ALL_OBJECTS table).

[Author]

Posts