error when trying to edit a Procedure or Package from SQL Developer
120847Sep 1 2010 — edited Nov 4 2010Thanks 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