Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error when trying to edit a Procedure or Package from SQL Developer

120847Sep 1 2010 — edited Nov 4 2010
Thanks in advance for any and all help.
First I am a relative new comer to Oracle but I do have extensive background with multiple RDBM's.

Here is the issue, we have a new installation of 11.1 that is up and running in the test environment with test data loaded that we will be accessing via Crystal Reports.
I am running SQL Developer and have created a Package, Parameter, Function and/or Type. All were entered via the SQL Worksheet and they execute from the worksheet via SQL and also via Crystal.
The issue I am having is that when I select from the connection tree and right mouse click any of the previously named objects and select Edit, SQL developer returns the following error: "An error Occured while opening SQLDEV.NAV:IdeConnections%2523thenthedatabasename//userID/PROCEDURE/procedurename
I open up the details and the first error listed is :JAVA.io.IOException: exception loading Procedure ......

I installed the latest JDK today after I ran across a document stateing the JDK was required but no that did not fist the error. I am thinking this has to do with permissions on some table that will need to be updated.

I have a couple concerns that I would like help with:
1) Is there something in SQL Developer that I need to change to allow Editing these menbers? We need to be able to edit these objects from within the SQL Developer for ease of maintainability.

2) If this is a permissions issue with some system tables, how do I go about determining what tables I need to ask to have the access granted.

2a) What tables actually hold the various object's code?
I have found references including Object_ID in USER_ARGUMENTS and USER_OBJECTS tables but I have no idea where the physical code is stored.

Please let me know if there is any other details needed to help us out.

Thanks again
Greg
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2010
Added on Sep 1 2010
6 comments
1,738 views