Syntax 1

[CTO1]

Trying to get to grips with user-defined exceptions by working through this example. It looks fine to me yet I keep getting
Error at Line 7:
ORA-06550: Encountered the symbol "INTO" when expecting one of the following: .,@;for<an identifier>

DECLARE
my_empid employee.empid%TYPE := 39334;
my_emp_record employee%ROWTYPE;
my_salary_null EXCEPTION;
BEGIN
SELECT * FROM employee
INTO my_emp_record
WHERE empid = my_empid;
IF my_emp_record.salary IS NULL THEN
RAISE my_salary_null;
END IF;
EXCEPTION
WHEN my_salary_null THEN
DBMS_OUTPUT.PUT_LINE ('Salary column was null for employee');
END;

Scratching my head --All help gratefully received

 

[SantaMufasa]

CTO,

You are VERY close...your INTO statement needs to immediately follow the expressions you SELECT, so it should read:

...BEGIN
    SELECT * INTO my_emp_record
    FROM employee
    WHERE empid = my_empid;...

Try that and let us know if you have success.

Mufasa
(aka Dave of Sandy, Utah, USA @ 20:19 (06May04) UTC (aka "GMT" and "Zulu"), 13:19 (06May04) Mountain Time)

 

[CTO1]

Thanks Santa
...you've given me the boost I need.

CTO1