Xref: alice comp.databases.oracle.server:56404
Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: michael_bialik@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Dynamic CREATE PROCEDURE
Date: Wed, 07 Jul 1999 19:38:53 GMT
Organization: Deja.com - Share what you know. Learn what you don't.
Lines: 40
Message-ID: <7m0acb$m9g$1@nnrp1.deja.com>
References: <37814ADF.3B867A87@midsys.co.uk> <3787f36d.9263129@newshost.us.oracle.com>
X-Article-Creation-Date: Wed Jul 07 19:38:53 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 4.01; Windows 98)
X-Http-Proxy: 1.1 x29.deja.com:80 (Squid/1.1.22) for client 212.25.76.123

Hi,

 If it works like on-the-fly creation of table - then
  the user is supposed to have direct "CREATE PROCEDURE"
  grant ( it is not enough to get it through role ).

   Michael.

In article <3787f36d.9263129@newshost.us.oracle.com>,
  tkyte@us.oracle.com wrote:
> A copy of this was sent to Leigh Warren <leighw@midsys.co.uk>
> (if that email address didn't require changing)
> On Mon, 05 Jul 1999 17:16:31 -0700, you wrote:
>
> >Hi,
> >
> >Can I create a stored procedure on-the-fly using OCI calls?
> >
> >Leigh..
>
> Yes.  Just execute it like you would any other statemtent -- like an
UPDATE or
> PLSQL block for example.
>
> --
> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to
Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated
June 21'st
>
> Thomas Kyte                   tkyte@us.oracle.com
> Oracle Service Industries     Reston, VA   USA
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>


Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.