Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Pb with statement drop table in stored procedure
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