Re: Calling Stoed Procedure via .bat file
From: <catherine_devlin_at_purpleturtle.com>
Date: 14 Aug 2001 15:00:22 GMT
Message-ID: <9lbee6$15k$1_at_news.netmar.com>
Date: 14 Aug 2001 15:00:22 GMT
Message-ID: <9lbee6$15k$1_at_news.netmar.com>
In article <b248cddc.0108091441.20403d50_at_posting.google.com>, Steven
<stevenjt_at_hotmail.com> writes:
>Can anyone explain the syntax for writing a batch file to call an
>Oracle 8i Stored Procedure? Thanks.
Well, if the batch file is running on a machine with SQL Plus, you can
sqlplus scott/tiger_at_orcl @script.sql
where script.sql is:
exec my_procedure();
exit;
- Catherine
http://profiles.yahoo.com/arcticturtle
- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net