Home » SQL & PL/SQL » SQL & PL/SQL » getting error while opening procedure or package (orcale 9i)
getting error while opening procedure or package [message #329935] Fri, 27 June 2008 01:49 Go to next message
singh.neerajin
Messages: 26
Registered: April 2008
Location: noida
Junior Member

Hi all,

I am getting the error while opening the pacakage or procedure:
Ora-942 error - Table or view does not exist.


Re: getting error while opening procedure or package [message #329940 is a reply to message #329935] Fri, 27 June 2008 02:03 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You are refering, in your code, to a table or view that does not exist.

Either it's been dropped since the package was compiled, or you're using dynamic SQL and are refering to a table that you can't see, or which doesn't exist.
Re: getting error while opening procedure or package [message #329943 is a reply to message #329940] Fri, 27 June 2008 02:08 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

If the table exists, verify that the owner of the procedure has the correct grants on that table which you are trying to access
Re: getting error while opening procedure or package [message #329985 is a reply to message #329935] Fri, 27 June 2008 03:33 Go to previous messageGo to next message
singh.neerajin
Messages: 26
Registered: April 2008
Location: noida
Junior Member

I am unable to open the pacakage or procedure. during the time of clicking on package or procedure im getting error.

I checked the permissions too.............
Re: getting error while opening procedure or package [message #329988 is a reply to message #329985] Fri, 27 June 2008 03:40 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The error message you get should list a line number for this error.

Have a look at the code round about that line number.
Re: getting error while opening procedure or package [message #329992 is a reply to message #329985] Fri, 27 June 2008 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
singh.neerajin wrote on Fri, 27 June 2008 10:33
I am unable to open the pacakage or procedure. during the time of clicking on package or procedure im getting error.

I checked the permissions too.............

Clicking?
Maybe you don't have the privilege to use your tool and no relation with the package itself.

Regards
Michel


Re: getting error while opening procedure or package [message #330049 is a reply to message #329985] Fri, 27 June 2008 07:53 Go to previous message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
singh.neerajin wrote on Fri, 27 June 2008 04:33
I am unable to open the pacakage or procedure. during the time of clicking on package or procedure im getting error.



I am going to assume all of the following. Some correct, some incorrect.
You are using something GUI tool like TOAD.
You opened TOAD in the morning and got a list of packages and procedures.
You did something else for hours and came back.
In that time, procedures and packages were dropped, moved, etc.
-or- the database is hosed because TOAD cannot find the SYSTEM tables that provide information on source code
Now you click on one and get your error message.


Of course, providing more meaningful information may help people decipher this puzzle.

Previous Topic: Connect By Clause - Child -> Parent (merged)
Next Topic: DATE ISSUES
Goto Forum:
  


Current Time: Sun Dec 04 20:53:07 CST 2016

Total time taken to generate the page: 0.08351 seconds