| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Invoking svrmgrl
Try putting the connect in the script:
shut.sql =
connect internal
shutdown immediate;
exit;
svrmgrl @shut
>From: "Witold Iwaniec" <wiwaniec_at_novalistech.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Invoking svrmgrl
>Date: Thu, 01 Mar 2001 08:16:02 -0800
>
>Hi
>
>In one of my applications, that connects to Oracle database, I
>generate a package and have to compile it. The platform of the
>application - Windows while database can be on a remote machine.
>
>I know that from my application I can call sqlplus to compile the
>package. For example:
>
>sqlplus user/password_at_my_db @c:\temp\my_script.sql
>
>but I think in some minimal installations you may not have sqlplus
>installed.
>
>I thought about calling svrmgrl but I don't think it accepts command
>line parameters. I tried to write small batch file:
>
>svrmgrl
>connect user/password_at_my_db
>@c:\temp\my_script.sql
>
>But it is not going to work - the problem is that the commands are
>executed as three separate commands while I need to write the
>batch file so that the connect... and @c:\tmp\... commands are
>executed by server manager. Can anyone show me the correct
>way to write the batch file?
>
>Or maybe there is another way - in my application I am already
>connected to the database using ODBC API.
>
>Thanks
>
>Witold
>
>
>
>
>
>======================================
>Witold Iwaniec
>Senior Software Developer
>NovaLIS Technologies
>wiwaniec_at_novalistech.com
>http://www.novalistech.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Witold Iwaniec
> INET: wiwaniec_at_novalistech.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike Killough INET: mwkillough_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Mar 01 2001 - 12:46:48 CST
 |
 |