Hi,

First, check what version of Oracle u are using. If it is not O8 then probably you should user DBMS_SQL package to create the table on the fly.

Second, If you want to create a table using Dynamic SQL, you must have CREATE TABLE or CREATE ANY TABLE privileges granted directly to your schema. Remember that roles are disabled during PL/SQL compilation and execution.

My guess would be that u must not have the necessary privileges to exeucte that DDL statement from this PL/SQL block.

Let me know if it helps

AD