Try putting the connect in the script:

shut.sql =
connect internal
shutdown immediate;
exit;

svrmgrl @shut



>From: "Witold Iwaniec" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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@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@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
>[EMAIL PROTECTED]
>http://www.novalistech.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Witold Iwaniec
>   INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mike Killough
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to