Re: calling sqlplus from batch job

Try this.
In your Unix's shell script :

sqlplus -s ggg/hhh_at_bbb << _SCRIPT_

    execute dbms_utility.analyze_schema('NNNN','COMPUTE') ;     quit
_SCRIPT_ poffs_at_tteam.com wrote in message <79q296$ns7$1_at_nnrp1.dejanews.com>...
>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;
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Feb 10 1999 - 20:05:43 CST