Re: Cannot create a new table from PL/SQL

When you are running a stored procedure, you only have privileges that are granted to you explicitly. You do not get privileges that are granted through a role.

So, if your account has CREATE TABLE through a role, you can't use that command in a stored procedure.

Your DROP TABLE command worked because you can always drop one of your own tables. You don't need a special privilege for that.

So, a quick and dirty way to solve your problem is to grant CREATE TABLE explicitly to your account.

-- 
Bob Swisshelm
Eli Lilly and Company
swisshelm_at_lilly.com