OraFAQ Forum: Server Administration » View has the same name of another schema

Home » RDBMS Server » Server Administration » View has the same name of another schema

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

View has the same name of another schema [message #55721]

Wed, 12 February 2003 06:58

viv
Messages: 11
Registered: February 2003

Junior Member

Hi,

I have a VIEW in one schema that has the exactly the same name as another schema. When I try to run a procedure in second schema. It generates "PLS-00302: component xxx must be declared" error. It is due to the VIEW which has the schema name. How can I make it work without change any name. Any way I can let Oracle know that I refer to a schema instead of a view?

Thanks in advance

viv

Report message to a moderator

Re: View has the same name of another schema [message #55723 is a reply to message #55721]

Wed, 12 February 2003 07:31

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

try adding the schema name.
like.
scott.view1
scott.view2
tom.view1

Report message to a moderator

Re: View has the same name of another schema [message #55725 is a reply to message #55723]

Wed, 12 February 2003 08:02

viv
Messages: 11
Registered: February 2003

Junior Member

I have a view ITEM in schema A, and a schema named as ITEM. When I try to refer objects(which are granted to A) in schema ITEM using ITEM.package1.procedure1 from schema A, it generates above error. If I drop the view ITEM from schema A. There is no problem.

However, I cannot afford to rename any of these two. Any solution that tell Oracle the ITEM in ITEM.package1.procedure1 is a schema object instead of a view object?

Report message to a moderator