Re: Running an Oracle Stored Procedure via batch file
From: Lowell Paden <paden_lv_at_nospam.yahoo.com>
Date: Fri, 10 Aug 2001 10:29:50 -0400
Message-ID: <n8Sc7.3$84.74_at_dit4.state.va.us>
Date: Fri, 10 Aug 2001 10:29:50 -0400
Message-ID: <n8Sc7.3$84.74_at_dit4.state.va.us>
I assume this will be running on an NT database server. Something like this should work:
Contents of batch file:
set oracle_sid=<sidname>
sqlplus -s logon/password _at_c:\sql\script.sql
Contents of c:\sql\script.sql:
<whatever sql you want to run>
exit
"Steven" <stevenjt_at_hotmail.com> wrote in message
news:b248cddc.0108091522.b93580b_at_posting.google.com...
> What is the syntax needed to open SQLplus, logon on, call an Oracle 8i
> stored procedure, and logoff via a batch file.
Received on Fri Aug 10 2001 - 16:29:50 CEST