Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Pb with statement drop table in stored procedure

Re: Pb with statement drop table in stored procedure

From: Alan Shein <alanshein_at_spambuster.erols.com>
Date: Thu, 12 Apr 2001 14:25:44 -0400
Message-ID: <9b4rtb$7c5$1@bob.news.rcn.net>

You have to use the DBMS_SQL package.

"Pierre HIRTH" <p.hirth_at_sbm.mc> wrote in message news:9b4g3d$ljt$1_at_news5.isdnet.net...
> Hi,
>
> Someone could tel me how can i do to compile this proc :
>
> CREATE OR REPLACE PROCEDURE BO.CREER_F0902
> AS
>
> i number;
>
> BEGIN
>
> i:=i+1;
> drop table bo.f0902;
>
> END;
>
> Thank's
>
>
Received on Thu Apr 12 2001 - 13:25:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US