Re: Stored procedure question.

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Sat, 19 May 2001 04:27:44 GMT
Message-ID: <3B05F633.44EE9F3E@pro-ns.net>

Ryn wrote:

> Hello folks,
>
> Do you you register a stored procedure with Oracle? I have created
> one but am not sure how to register it. Also, if you make modifications
> to a stored procedure, do you have to re-register it? Do the changes
> show up dynamically as long as the interface is the same? I am trying
> to find out what happens each time I update the stored procedure from
> a database perspective.
>
> Thanks for any info,
>
> - Ryn

Once you created (recreated) stored procedure, you can use it. To let other people to use it, use grant execute on <procedure_name> to <username>. Received on Fri May 18 2001 - 23:27:44 CDT