Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Eclipse/SQL Explorer - can't list procedures in structure view

 
Carl Zeigler
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I have installed the SQL Explorer plugin for Eclipse. I have the connection working OK but if I connect with a read only ID, I can only view a list of the database tables. The functions and procedure elements of the database structure view will not populate with the functions/procedures in the schema.

If I connect with an ID that has update permissions to the database, the function and procedure elements of the database structure view populate correctly.

I am connecting to an Oracle database (10.2.0.4.0) using the Oracle thin driver from oracle.jdbc.OracleDriver in ojdb6.jar. I am using version 3.5.2 of the Eclipse platform on a WinXP machine.

Incedentally, I tried to install the Toad plugin for Eclipse and have the exact same issue.

Can anyone please suggest a solution? I need to be able to use the read only ID in order to access or view database tables, procedures and functions in a production environment.

Thank you,
Carl
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic