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: Emil Chou <emil_at_ms1.hinet.net>
Date: 10 Feb 1999 09:41:39 GMT
Message-ID: <01be54d9$a8918ca0$49aa43d2@ams>


at window platform
PLUS33W.EXE user_name/password_at_connect_string file

kiel <kiel_at_webpre.com> 次寫入到主題 <36C0986F.4DFD154E_at_webpre.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')
> >
> Maybe I don't exactly understand but this is how I call sqlplus from
> shell scripts
>
> sqlplus -s @file
>
> where file.sql contains the sql script I want to be executed, which of
> course can contain PL/SQL blocks.
>
> the -s just suppresses some output, and might be OS dependent.
>
> Christian
>
Received on Wed Feb 10 1999 - 03:41:39 CST

Original text of this message

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