Re: Advanced script error

From: srivenu <srivenu_at_hotmail.com>
Date: 13 Oct 2002 23:29:27 -0700
Message-ID: <1a68177.0210132229.5b86967c@posting.google.com>

You can run any script using RUN.
The ORA-00922: missing or invalid option has several possiblities that may be the cause.

Try this

set echo off
set verify off
set sqlcase upper

accept x_employee_id prompt 'Enter Employee ID"'
accept x_last_name prompt 'Enter employee last name:'
accept x_first_name prompt 'Enter employee first name:'
accept x_middle_initial prompt 'Enter middle initial:'
accept x_title prompt 'Enter middle_initial:'

select employee_id, last_name, first_name, middle_initial, title from employee where
  "EMPLOYEE_ID" = 'x_employee_id'

  and   "LAST_NAME" = 'x_last_name'
  and   "FIRST_NAME" = 'x_first_name'
  and   "MIDDLE_INITIAL" = 'x_middle_initial'

  and title = 'x_title'

regards
Srivenu Received on Mon Oct 14 2002 - 01:29:27 CDT