Re: Help on PL/SQL - Solved
Date: Fri, 21 Jan 2000 20:21:14 -0800
Message-ID: <Au8i4.8692$pk.103533_at_news3.mia>
This works - execute immediate 'create table SCOTT.STORERANK (ENAME
VARCHAR2(25),JOB VARCHAR(25), RANKNO NUMBER(5))';
"Technical" <technical_at_fma-systems.com> wrote in message
news:8679it$47q$1_at_lure.pipex.net...
> The answer to this is simple. You cannot create or drop tables under
PL/SQL
> at all. You must create the table under SQLPLUD beforehand. Something I
> found out only a few days ago.
>
> Tom Deseamus <tdeseamus_at_digital-hire.com> wrote in message
> news:VHFh4.499$Xs.11873_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 Sat Jan 22 2000 - 05:21:14 CET