Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00942 (Oracle 10.2.0.3.0 64 bit)
ORA-00942 [message #387947] Sun, 22 February 2009 07:12 Go to next message
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 Go to previous message
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

Previous Topic: Sort alphanumberic column
Next Topic: Hierachical query based on column value
Goto Forum:
  


Current Time: Sun Feb 16 00:35:18 CST 2025