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

Home -> Community -> Usenet -> c.d.o.server -> Re: HELP : DDL in procedures ?

Re: HELP : DDL in procedures ?

From: <michael_bialik_at_my-deja.com>
Date: 2000/03/30
Message-ID: <8c0ha0$ps9$1@nnrp1.deja.com>#1/1

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

Original text of this message

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