Re: dynamic SQL question

this error occurs, when you don't have the privileges for the sql-command you are trying to execute with the dbms_sql package. Note that you must have been given the privileges DIRECTLY, so NOT via a database role. There are reasons why this is implemented this way in Oracle, but that's a different story...

solution:
- connect as sys or system

• execute the command 'grant create table to <user_name>', replace <user_name> by the name of the user which creates the procedure containing the dynamic sql.

Good luck

Jac. Received on Thu Jan 07 1999 - 00:00:00 CST