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
|
|
|
|
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?
|
|
|
|
|