Re: HELP : DDL in procedures ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/03/30
Message-ID: <954442783.11740.0.pluto.d4ee154e@news.demon.nl>#1/1

Yes, use the dbms_sql package in Oracle 7 and Oracle 8.0, use execute immediate in Oracle 8i

Hth,

Sybrand Bakker, Oracle DBA

Joao Ricardo B. Oliveira <jricardo_at_ipb.pt> wrote in message news:8c035q$cl2$1_at_pan.ipb.pt...
> Hi there...
>
> Is it possible to have a procedure with Data Definition Language
> (Create, drop, etc) ?
>
> --
> ----------------------------------------------------------
> - Joao Ricardo B Oliveira jricardo_at_ipb.pt - Oracle DBA
> - EURO2004 http://welcome.to/euro2004
> - HOMEPAGE http://www.ipb.pt/~jricardo/myhome.swf
> ----------------------------------------------------------
>
>
>
Received on Thu Mar 30 2000 - 00:00:00 CST