> I logged on as "scott/tiger" in sqlplus, and entered "start test" to
> store this procedure. ***BUT*** in this procedure, I also like to access
> a table "address" which is owned by the user "grace", and "grace"
> granted the privilege of using this table to the user "scott/tiger".
> What's the syntax to use in this procedure? I tried
> select zip into out_zip from grace.address where aname=upper('james');
> but I got the error message
> "PLS-00201: "IDENTIFIER GRACE.ADDRESS must be declared".
I'll bet the mistake you're making is that GRACE isn't the name of the
tablespace (EQU schema) in which the table is located. GRACE is just the
name of the user.
-djc
Received on Wed Nov 05 1997 - 00:00:00 CST
