Re: Advanced script error

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:39:23 CDT