Re: Help on PL/SQL
From: Oracle Enterprise Internet Tools Product Management <no_replies_at_uk.oracle.com>
Date: Tue, 25 Jan 2000 22:53:19 -0000
Message-ID: <86l9p5$ij7$1_at_inet16.us.oracle.com>
Date: Tue, 25 Jan 2000 22:53:19 -0000
Message-ID: <86l9p5$ij7$1_at_inet16.us.oracle.com>
If you're using 8i - check out the EXECUTE IMMEDIATE command, that replaces DBMS_SQL
-- Regards Jason ____________________________________________________________________________ __ Jason Pepper - Enterprise Internet Tools Product Management ____________________________________________________________________________ __ Opinions are mine and do not necessarily reflect those of Oracle Corporation Scott Kronheim <skronheim_at_synertechsystems.com> wrote in message news:388730EA.B50B23A0_at_synertechsystems.com...Received on Tue Jan 25 2000 - 23:53:19 CET
> Actually, I think you can issue DDL in PL/SQL, but you need to use
> dynamic SQL and the DBMS_SQL package (at least in stored procedures).
> Try that option before giving up; I've used dynamic SQL, but never to
> issue DDL statements, so I can't speak from experience.
>
> If you are working from Oracle Forms, use the FORMS_DDL builtin package.
>
> -----
> Scott Kronheim
>
>
> Technical wrote:
> >
> > 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,
> > >
> > >
>
> --