Re: Exception Handling

Nevermind...

I found out that an anonymous block gets executed from SQL*plus which can use roles (for create table priviledges). However, PL/SQL needs explicit object priviledges. Once I granted an explicit 'CREATE ANY TABLE' everything worked fine :')

-greg

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!