Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Got error...ORA-06550: line 9, column 98: PLS-00201: identifier 'S.SALARY' must be declared

3416816Mar 17 2017 — edited Apr 3 2017

declare

   F_first_name hr.employees.FIRST_NAME%type;

   L_last_name hr.employees.LAST_NAME%type;

   E_emp_id    hr.employees.EMPLOYEE_ID%type;

   S_salary    hr.employees.SALARY%type;

   H_hire_date hr.employees.HIRE_DATE%type;

begin

    SELECT first_name, last_name, salary, employee_id, hire_date INTO F_first_name, L_last_name, S.salary,

    E_emp_id, H_hire_date from hr.employees where salary > 5000;

    dbms_output.put_line(F_salary);

    dbms_output.put_line(L_last_name);

    dbms_output.put_line(S_salary);

    dbms_output.put_line(E_emp_id);

    dbms_output.put_line(H_hire_date);

end;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2017
Added on Mar 17 2017
18 comments
2,266 views