someone is using dbms_lock and while they are - you cannot change it's associated set of privileges.

what is an anchored datatype? Ok, I think I know what you mean by an "anchored datatype" (where did you pick up that nomenclature?)

It is probably caused by this:

http://asktom.oracle.com/pls/asktom/ASKTOM.download_file?p_file=6551289900368934430

consider this example, when B is granted access to A.T via a role (connect), B can reference a.t.x%type in an anonymous block but NOT a compiled stored object such as a stored procedure (or view or package or trigger or...)

when granted select directly, B can reference it.

ops$tkyte%ORA11GR2> create user a identified by a;

User created.

ops$tkyte%ORA11GR2> create user b identified by b;

User created.

ops$tkyte%ORA11GR2> grant create session, create table to a;

Grant succeeded.

ops$tkyte%ORA11GR2> alter user a default tablespace users quota unlimited on users;

User altered.

ops$tkyte%ORA11GR2> 
ops$tkyte%ORA11GR2> grant connect, create procedure to b;

Grant succeeded.

ops$tkyte%ORA11GR2> 
ops$tkyte%ORA11GR2> connect a/a
Connected.
a%ORA11GR2> create table t ( x int );

Table created.

a%ORA11GR2> grant select on t to connect;

Grant succeeded.

a%ORA11GR2> 
a%ORA11GR2> connect b/b
Connected.
b%ORA11GR2> 
b%ORA11GR2> declare
  2          x a.t.x%type;
  3  begin
  4          null;
  5  end;
  6  /

PL/SQL procedure successfully completed.

b%ORA11GR2> 
b%ORA11GR2> create or replace procedure p
  2  as
  3          x a.t.x%type;
  4  begin
  5          null;
  6  end;
  7  /

Warning: Procedure created with compilation errors.

b%ORA11GR2> show errors
Errors for PROCEDURE P:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/4      PL/SQL: Item ignored
3/4      PLS-00201: identifier 'A.T' must be declared
b%ORA11GR2> 
b%ORA11GR2> 
b%ORA11GR2> connect a/a
Connected.
a%ORA11GR2> grant select on t to b;

Grant succeeded.

a%ORA11GR2> 
a%ORA11GR2> connect b/b
Connected.
b%ORA11GR2> create or replace procedure p
  2  as
  3          x a.t.x%type;
  4  begin
  5          null;
  6  end;
  7  /

Procedure created.

Here's a transcript
====================

Why do I get a "ORA-01031: insufficient privileges" or "PLS-00201: identifier 'x' must be declared" in my stored procedures?

Roles are never enabled during the execution of a procedure except in the special case of Invokers Rights which is a new feature in Oracle8i, release 8.1.
This fact is documented application developers guide:


Privileges Required to Create Procedures and Functions
To create a stand-alone procedure or function, or package specification or
body, you must meet the following prerequisites:

• You must have the CREATE PROCEDURE system privilege to create a
procedure or package in your schema, or the CREATE ANY
PROCEDURE system privilege to create a procedure or package in
another user’s schema.

Attention: To create without errors, that is, to compile the procedure
or package successfully, requires the following additional privileges:
The owner of the procedure or package must have been explicitly
granted the necessary object privileges for all objects referenced within
the body of the code; the owner cannot have obtained required
privileges through roles.

If the privileges of a procedure’s or package’s owner change, the procedure
must be reauthenticated before it is executed. If a necessary privilege to a
referenced object is revoked from the owner of the procedure (or package), the
procedure cannot be executed.

</quote>
Try this:


SQL> set role none;
SQL> "statement you want to test to see if it'll work in a procedure"

If you can do it in plus with no roles you can do it in a procedure. If you can't, you must have the privelege from a role and hence won't be able to do it in a procedure (unless you are using Invokers rights in Oracle8i. See the PLSQL documentation for more information on this feature and make sure you understand the ramifications). To be able to perform that operation in a typical procedure, you need to have that privelege granted directly to you.