Re: PL/SQL Help

From: Tom Deseamus <tdeseamus_at_digital-hire.com>
Date: Thu, 20 Jan 2000 10:10:06 -0800
Message-ID: <JrGh4.617$Xs.14185@news4.mia>

Thanks, I'm running 8i. I've tried execute_immediate('CREATE TABLE STORERANK1(ENAME VARCHAR2(25),RANKNO NUMBER(5));'); but that won't complie either. Can you help on the syntax or point me to a help file (I have looked).

Thanks,
Tom

"Sybrand Bakker" <postmaster_at_sybrandb.demon.nl> wrote in message news:948382100.8871.0.pluto.d4ee154e_at_news.demon.nl...
> DDL is only supported through using the dbms_sql package (v7) or
> execute_immediate (v8)
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Tom Deseamus <tdeseamus_at_digital-hire.com> wrote in message
> news:JIFh4.502$Xs.11727_at_news4.mia...
> > 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,
> >
> >
>
>
Received on Thu Jan 20 2000 - 12:10:06 CST