Re: Stored procedure question.

How do upgrades work? Do I just re ploy the stored procedure? Is there any registration necessary when you install it?

• Ryan

"Alex Filonov" <afilonov_at_pro-ns.net> wrote in message news:3B05F633.44EE9F3E_at_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 Sat May 19 2001 - 09:23:10 CDT