I am sure you realize in order to perform DDL in PL/SQL stored procedures you have to use dynamic SQL - native dynamic SQL in Oracle8i or the DBMS_SQL package in earlier versions.However, I suggest you re-evaluate your needs and try to avoid creating tables in stored procedures.