Invoking svrmgrl

From: Witold Iwaniec <wiwaniec_at_novalistech.com>
Date: Thu, 01 Mar 2001 10:05:48 -0800
Message-ID: <F001.002C0E02.20010301081603@fatcity.com>

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). Received on Thu Mar 01 2001 - 12:05:48 CST