Re: Beginners Question on Stored Procedures

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 31 May 2002 17:01:59 GMT
Message-ID: <3CF7AC81.9ABE0716@exesolutions.com>

Victor Kaminsky wrote:

> Hi all,
>
> I have created a stored procedure under 8.1.7 on Linux 7.3(Kernel
> 2.4.12).
> There a some DBLinks and I wonder how I can create this procedure on
> every instance, not just on the one i am logged on. Do I have program
> a loop for every entry in oratab, or can I do this under SQL*Plus? I
> do not want to connect to each instance and type the Procedure over
> and over again.
>
> Thank you for your help.
>
> VK

Why would you want to duplicate the same code on multiple machines? A strong desire to create a maintenance headache?

If you are still intent on doing this ... you will need to log onto each machine.

Daniel Morgan Received on Fri May 31 2002 - 12:01:59 CDT