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

Home -> Community -> Usenet -> c.d.o.server -> Re: Advanced script error

Re: Advanced script error

From: Peter van Rijn <pgm.van.rijnRM_at_THIShccnet.nl>
Date: Fri, 11 Oct 2002 21:59:51 +0200
Message-ID: <ao7aep$i8e$1@news.hccnet.nl>


David is right, "run" executes the SQL-statement that's currently in the buffer. And since "set echo off" is not a SQL-statement (it's a SQL*Plus command) the error occurs. Just use "start"or "@" to 'run' the script.

Peter

"David Sharples" <david.sharples3_at_ntlworld.com> schreef in bericht news:AOFp9.4459$4r1.66115_at_newsfep3-gui.server.ntli.net...
> arent u suposed to put start employee_advanced_script at the beginning
>
> havent heard of run before
>
>
> "gamaz" <gamaz_at_earthlink.net> wrote in message
> news:S6Fp9.22256$lV3.2133976_at_newsread1.prod.itd.earthlink.net...
> > Hi, I have posted the requirement of advanced script on an earlier post.
I
> > could get a small
> > reference in an internet site about script. I am trying to run a script.
> > However, I am getting a error message as before. I could not yet figure
it
> > out why. I would aprreciate any help in this matter. Thanks.
> >
> >
> > SQL> run employee_advanced_script
> > 1 set echo off
> > 2 set verify off
> > 3 set sqlcase upper
> > 4 accept x_employee_id prompt 'Enter Employee ID"'
> > 5 accept x_last_name prompt 'Enter employee last name:'
> > 6 accept x_first_name prompt 'Enter employee first name:'
> > 7 accept x_middle_initial prompt 'Enter middle initial:'
> > 8 accept x_title prompt 'Enter middle_initial:'
> > 9 select employee_id, last_name, first_name, middle_initial, title
> > 10 from employee where
> > 11 employee_id = 'x_employee_id'
> > 12 and last_name = 'x_last_name'
> > 13 and first_name = 'x_first_name'
> > 14 and middle_initial = 'x_middle_initial'
> > 15* and title = 'x_title'
> > set echo off
> > *
> > ERROR at line 1:
> > ORA-00922: missing or invalid option
> >
> >
>
>
Received on Fri Oct 11 2002 - 14:59:51 CDT

Original text of this message

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