Re: Dynamic CREATE PROCEDURE

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 05 Jul 1999 18:03:46 GMT
Message-ID: <3787f36d.9263129@newshost.us.oracle.com>

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 Received on Mon Jul 05 1999 - 13:03:46 CDT