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