Re: Drop Table in PLSQL Script
From: Rich H <qqaazz_at_hotmail.com>
Date: 25 Jun 2002 17:10:39 -0700
Message-ID: <b5695d57.0206251610.63d74520_at_posting.google.com>
Date: 25 Jun 2002 17:10:39 -0700
Message-ID: <b5695d57.0206251610.63d74520_at_posting.google.com>
"Bliss" <ignorance_is_bliss_at_123india.com> wrote in message news:<3d18b7d9$1_1_at_news.tm.net.my>...
> hi,
>
> yes, drop is not allowed in a PL/SQL script.. you cannot use any DML from
> within a PL/SQL block...
>
Are you sure
Try this if you are using Oracle 8i or above.
declare
c varchar2(2000) ;
begin
c := 'drop table z' ;
EXECUTE IMMEDIATE c ;
end;
/
Received on Wed Jun 26 2002 - 02:10:39 CEST