Re: Help on PL/SQL

Data definition language (DDL) statements are not allowed under PL/SQL.

You could use the DBMS_SQL package to create dynamic SQL statements to create tables that way.

Tom Deseamus <tdeseamus_at_digital-hire.com> wrote:
: How come I cannot run this in a PL/SQL procedure

: CREATE TABLE STORERANK(ENAME VARCHAR2(25),RANKNO NUMBER(5));

: The compiler has a problem with the CREATE word.

: Thanks,

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Ivan Samuelson                 * 
Staff Support Coordinator and  * isamuels_at_columbus.rr.com
Information Systems Consultant *
Metro Information Services     * http://home.columbus.rr.com/isamuels
http://www.MetroIS.com         *
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-