OraFAQ Forum: Client Tools » Table or view does not exist

Home » Other » Client Tools » Table or view does not exist (Toad, 9.1.0.62, Windows 2003 server R2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Table or view does not exist [message #445387]

Mon, 01 March 2010 06:35

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Hi,

In toad 9.1.0.62 version, when i open a package in schema browser. It shows table or view doesn't exist.

But the package seems to be in valid state.

I also used other schema's to open that schema packages it opens with no problems.

Please help.

Report message to a moderator

Re: Table or view does not exist [message #445388 is a reply to message #445387]

Mon, 01 March 2010 06:37

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Try compiling the package with sqlplus

Report message to a moderator

Re: Table or view does not exist [message #445393 is a reply to message #445388]

Mon, 01 March 2010 08:20

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

The package is already in the valid state. I want to view the code of that package. When i click the package in toad --> Schema browser --> packages. It show table or view doesn't exist.

Report message to a moderator

Re: Table or view does not exist [message #445394 is a reply to message #445387]

Mon, 01 March 2010 08:24

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

Then it sounds like a bug in your version of TOAD. In which case you'd be better off using Quests forums.

Report message to a moderator

Re: Table or view does not exist [message #445401 is a reply to message #445394]

Mon, 01 March 2010 09:32

srini_thiru
Messages: 133
Registered: May 2008

Senior Member

Thanks for your direction.

But when i grant DBA privilege to that user then i can view the package. It sounds like some privilege needed to view the packages of own schema.

Report message to a moderator

Re: Table or view does not exist [message #445402 is a reply to message #445401]

Mon, 01 March 2010 09:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> It sounds like some privilege needed to view the packages of own schema.

or logged in schema is really not owner of package.

Report message to a moderator

Previous Topic:	cant connect to isql plus
Next Topic:	Run Toad off a USB Flash

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 06:00:17 CST 2024