Re: Help on PL/SQL

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.

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,
> >
> >

--