Re: Dynamic CREATE PROCEDURE

From: <michael_bialik_at_my-deja.com>
Date: Wed, 07 Jul 1999 19:38:53 GMT
Message-ID: <7m0acb$m9g$1@nnrp1.deja.com>

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_at_newshost.us.oracle.com>, tkyte_at_us.oracle.com wrote:
> A copy of this was sent to Leigh Warren <leighw_at_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_at_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. Received on Wed Jul 07 1999 - 14:38:53 CDT