Hi All,

I am working in Oracle10g and I have been trying to run the following query, and am getting an error:

Query:

sql Syntax (Toggle Plain Text)

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;
/

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; /

Error:

sql Syntax (Toggle Plain Text)

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>

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?