Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Advanced script error
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
*
ERROR at line 1:
ORA-00922: missing or invalid option
Received on Fri Oct 11 2002 - 13:53:38 CDT