Claus Pedersen
Member³
I have the following code:
When the cursor is on a column name in line 4, nothing is marked in line 5. When cursor is on a value in line 5, the corresponding column name is marked in line 4.
If I delete the line with RETURNING..INTO, everything works: both columns and values are marked as designed.
Could this be fixed?
Code:
DECLARE
my_employee_id INT;
BEGIN
INSERT INTO employees (employee_id, last_name, email, hire_date, job_id, salary, manager_id, department_id)
VALUES (employees_seq.nextval, 'Fripp', 'AFRIPPX', TRUNC(SYSDATE), 'ST_MAN', 8200, 100, 50)
RETURNING employee_id INTO my_employee_id;
END;
When the cursor is on a column name in line 4, nothing is marked in line 5. When cursor is on a value in line 5, the corresponding column name is marked in line 4.
If I delete the line with RETURNING..INTO, everything works: both columns and values are marked as designed.
Could this be fixed?