RE: Invoking svrmgrl

Thanks for the reply. It does the job.

I didn't try to invoke svrmgrl with script on the command line. I tried:
svrmgrl connect system/manager_at_my_db

and the command failed with Server Manager Command Line error...

Thanks

Witold

On 1 Mar 2001, at 19:45, Белов Игорь Иосифови ч wrote:

> s1.bat
> ====
> svrmgrl @s2.sql
> <eof>
>
> s2.sql
> =====
> connect system/manager
> @my_sql.sql
> <eof>
>
> my_sql.sql
> ========
> select * from scott.emp
> /
> exit
> /
> <eof>
>
> > -----Original Message-----
> > From: Witold Iwaniec [mailto:wiwaniec_at_novalistech.com]
> > Sent: Thursday, March 01, 2001 7:16 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Invoking svrmgrl
> >
> > 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).
> > Вирусы не обнаружены. Проверил AVP for MS Exchange.

--
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).