Re: Calling shell command from stored procedure

<daning_at_my-deja.com> wrote in message news:8ptt6a$gr0$1_at_nnrp1.deja.com...
> Hi all,
>
> 1. What do you think the best way to call OS shell command from stored
> procedure?

i'd recommend not calling an external procedure at all, especially not to run a shell script.

> 2. Since the only way I know is to create an external procedure to call
> a DLL. You know that setting up calling external procedure is
> complicated in Oracle. I want our product could be automatically
> installed. I don’t want the DBA to do some manual work for our
> products. So I am going to write a small program to set up tnsname.ora
> and listener.ora. But I get a problem that when in a multiple instance
> environment; I just could not find the files that the listener uses are
> located in with Oracle home directory. I searched the registry, but I
> could not find how the Oracle did the trick.

I think your time would be better spent creating clear, concise, and accurate documentation which defines the Oracle configuration requirements for your product. Allow the DBA to review the requirements, and make the changes.

If you want to make setup and configuration "easy" for the the windows crowd, then include a "wizard" that runs as part of the installation and configuration process. It could review the current environment, configuration settings, etc. and make specific recommendations, display the recommended changes to the user, and prompt the user to allow the changes to be applied automagically.

And just to let you know, the first time your (or anyone else's) "product" invokes a procedure that modifies _any_ of my oracle configuration files, that "product" will be removed from my systems. period.

>
> Thank you in advance.
>
> Daning
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 15 2000 - 20:43:59 CDT