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

create or replace synonym abc for abc@<db_link>;
<package created>
Create or replace package body p1
l_tst varchar2(10);
select <col_name> into l_tst from abc;

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: 65079
Registered: March 2007
Location: Nanterre, France, http://...
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?


[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: Fri Jul 21 00:02:21 CDT 2017

Total time taken to generate the page: 0.07758 seconds