Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: calling sqlplus from batch job

Re: calling sqlplus from batch job

From: <amanda.leaman_at_atl.bluecross.ca>
Date: Thu, 11 Feb 1999 20:29:47 GMT
Message-ID: <79vejd$fvh$1@nnrp1.dejanews.com>


In article <79q296$ns7$1_at_nnrp1.dejanews.com>,   poffs_at_tteam.com wrote:
> i'm trying to create a batch file that calls sqlplus, then calls a procedure.
> What is the syntax for such a procedure? this is what i want to do: ie
> sqlplus ggg/hhh_at_bbb execute dbms_utility.analyze_schema('NNNN','COMPUTE')
>
> thanks in advance.
>
> Stephen Poff
> poffs_at_tteam.com&#137;
>

Here's what works in our Unix environment:

              sqlplus ggg/hhh_at_bbb @filename

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 11 1999 - 14:29:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US