facebook

Packages , Procedures , functions

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #222274 Reply

    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

    #222382 Reply

    support-jeff
    Member

    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.

    #222460 Reply

    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

    #222498 Reply

    support-jeff
    Member

    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?

    #222522 Reply

    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

    #222524 Reply

    vdbdavid
    Member
    #222528 Reply

    support-jeff
    Member

    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).

Viewing 7 posts - 1 through 7 (of 7 total)
Reply To: Packages , Procedures , functions

You must be logged in to post in the forum log in