Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP : DDL in procedures ?
Hi.
Check that your user have all grants ( CREATE/DROP/ etc. ) directly and NOT via ROLE.
HTH. Michael.
In article <954442783.11740.0.pluto.d4ee154e_at_news.demon.nl>,
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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
> > ----------------------------------------------------------
> >
> >
> >
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Mar 30 2000 - 00:00:00 CST