Re: Pb with statement drop table in stored procedure

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Tue, 17 Apr 2001 11:09:32 +0100
Message-ID: <987502207.24440.0.nnrp-12.c30bdde2@news.demon.co.uk>

or 'execute immediate' under Oracle 8i would be better. Check out "dynamic sql" in the manual.

"Alan Shein" <alanshein_at_spambuster.erols.com> wrote in message news:9b4rtb$7c5$1_at_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 Tue Apr 17 2001 - 05:09:32 CDT