Re: dynamic SQL with DBMS_SQL

DBMS_SQL needs direct permissions, not permissions granted to groups. Make sure with your DBA that you have create privileges specifically granted to you, not a group that you belong to.

--
Tom Mettling
W.T. Chen & Company, Inc.
mettlingt_at_wtchen.com
SHO wrote:



> Hi ,

> I am attempting to use DBMS_SQL to dynamically create tables or views.

>

> These are my sample codes:

>


....