ORA-00942 [message #387947] |
Sun, 22 February 2009 07:12  |
mrk_anand
Messages: 7 Registered: December 2007
|
Junior Member |
|
|
Experts,
I am facing a strange problem in our database.
We use synonyms across Databases using dblinks as we use the synonyms in our packages. The package is valid but while executing the error comes table or view does not exist.
e.g
create or replace synonym abc for abc@<db_link>;
<package created>
Create or replace package body p1
......
l_tst varchar2(10);
Begin
select <col_name> into l_tst from abc;
.......
End;
While executing the package we get the error ORA-00942 table or view does not exist for the synonym abc.
|
|
|
Re: ORA-00942 [message #387949 is a reply to message #387947] |
Sun, 22 February 2009 07:43  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Answered twice in the last 10 days and a zillion times over the web.
Did you search if the answers are valid for you?
If not why?
Regards
Michel
[Updated on: Sun, 22 February 2009 07:44] Report message to a moderator
|
|
|