Re: Help on PL/SQL
From: Technical <technical_at_fma-systems.com>
Date: Thu, 20 Jan 2000 15:25:12 -0000
Message-ID: <8679it$47q$1_at_lure.pipex.net>
Date: Thu, 20 Jan 2000 15:25:12 -0000
Message-ID: <8679it$47q$1_at_lure.pipex.net>
[Quoted] [Quoted] The answer to this is simple. You cannot create or drop tables under PL/SQL [Quoted] 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 Thu Jan 20 2000 - 16:25:12 CET