Development vs Test

From: <avilner_at_usa.net>
Date: Mon, 01 Mar 1999 19:02:52 GMT
Message-ID: <7beo8m$vaq$1@nnrp1.dejanews.com>

Hello,

We have a schema (DEV) in the database, that owns all tables, indexes, sequences, etc. There is also a set of public synonyms on the objects. If I were to log in with my user ID (ABV), I can issue the following query:

  select count(*)
  from PROP_HDR_142;

In this case, public synonyms are used to resolve the reference to the DEV.PROP_HDR_142. However, if I try to create procedure:

create or replace procedure proc_test
is

        i number;
begin

	select count(*)
	into i
	from prop_hdr_142;

end;
/
show errors;

... I get the following error:

7/7      PLS-00201: identifier 'DEV.PROP_HDR_142' must be declared
5/2      PL/SQL: SQL Statement ignored

I have CREATE PROCEDURE privilege granted to user ABV, and ABV also has SELECt/INSERT/UPDATE/DELETE privileges on all of DEV's tables.

Why would the SELECT work, but not the procedure?

Thank you in advance.

Alex Vilner

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 01 1999 - 13:02:52 CST