I am working in Oracle10g and I have been trying to run the following query, and am getting an error:
SET VERIFY OFF VARIABLE emp_salary NUMBER ACCEPT empno PROMPT 'Please enter a valid employee number: ' SET AUTOPRINT ON DECLARE empno NUMBER(6):= &empno; BEGIN SELECT salary INTO :emp_salary FROM employees WHERE employee_id = empno; END; /
empno NUMBER(6):= ; * ERROR at line 2: ORA-06550: line 2, column 19: PLS-00103: Encountered the symbol ";" when expecting one of the following: ( - + case mod new not null <an identifier> <a double-quoted delimited-identifier> <a bind variable> avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date <a string literal with character set specification> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with character set specification> <an alternatively-quoted S EMP_SALARY ---------- SQL>
If the error shows up distorted...the asterisk is located under the semi-colon in the error...
Could anyone guide me accordingly?