Using public synonym in a procedure

From: Stanley Fung <sfung_at_mdsi.bc.ca>
Date: Thu, 28 Jan 1999 14:24:57 -0800
Message-ID: <36B0E3B9.5D5A@mdsi.bc.ca>

Hi, all,

I have a strange problem, probably that's the way Oracle works.

I have a procedure which selects data from a public synonym, ex named scott_emp. When I create the procedure, I have this error:

PLS-00201: identifier 'scott.emp' must be declared

In fact, I try this:
select count(*) from scott_emp;
select count(*) from scott.emp;

Both work fine. If I do this in the procedure: create or replace procedure get_emp is
...

  select count(*) from scott_emp;
...

I get PLS-00201 error.

Has anyone seen this before? Or know what's wrong?

Please send response directly to me, as I don't often read messages from newsgroup. Thanks in advance.

--

---

Stanley Fung, Database Designer
Mobile Data Solutions Inc.

---

10271 Shellbridge Way,       | Direct Line: (604)207-6290
Richmond, B.C.               | Tel:         (604)207-6000
Canada V6X-2W8               | Fax:         (604)207-6060
http://www.mdsi-advantex.com | E-Mail:      sfung@mdsi.bc.ca
============================================================

Received on Thu Jan 28 1999 - 16:24:57 CST