Dexter wrote:
> 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
>
Pointers? Here's one: are roles enabled during the
execution of PL/SQL?
--
Regards,
Frank van Bortel
Received on Mon Feb 07 2005 - 11:26:41 CST
