مشكلة فى الbind variables

[rekp]

السلام عليكم
انا عندى مشكلة فى كتابة هذا الكود ومش عارف حلها اية ارجو الحل منكم
وشكرا

variable emp_salary numberbegin
select salary into :emp_salary
from employees
where employee_id=178;
end;
print emp_salary


select first_name,last_name
from employees
where salary=:emp_salary;

[ahmed_source]

VARIABLE EMP_SALARY NUMBER
BEGIN
SELECT SALARY 
INTO :EMP_SALARY
FROM EMPLOYEES 
WHERE EMPLOYEE_ID = 178;
END;
PRINT EMP_SALARY
SELECT FIRST_NAME, LAST_NAME FROM EMPLOYEES
WHERE SALARY=:EMP_SALARY;