Strange ORA_942

Hi,

I'm using oracle 9.2.0.5 and the following sql is part of a rather large ksh script, so i'm just giveing teh snippet that gives me issues. I get "ORA-00942: table or view does not exist" when i try executing the following.

DELCARE
.
.
.

BEGIN
.
.

DropStmt := 'DROP TABLE '||dtlTable||' CASCADE CONSTRAINTS' ; EXECUTE IMMEDIATE DropStmt ;
.
.

END;
/

I log in as user "abc" and the table belongs to some other schema "def".
I belong to a ROLE that has ALL the permissions to objects in "def" schema.

When i log into sqlplus (not from script) i'm able to describe the table and select rows from the table.

I have 2 questions now.

1. when i'm able to see this table when i login using sqlplus as user "abc" why does it error out saying "942", shouldnt it say some access issues if there is a problem.
2. I belong to a role that has all permissions to objects in "def" schema, why am i not able to delete the table?

Any help or pointer would be of great help.

-Thanks,
Dexter Received on Mon Feb 07 2005 - 11:06:41 CST