I am using Oracle SQL developer. I am running a query on employees table which is by default, having columns like first_name, last_name, employee_id, email, phone_no, hire_date, job_id, salary, commission_pct, manager_id, department_id.
I am writting a report that displays the last name and salary of employees who earn more than an amount that the user specifies after a prompt. If you enter 12000, it should display all employees earning more than 12000. Eg: Salary_value: 12000.
My report is like this
select last_name, salary
from employees
where employees.salary>&sal;
But I am getting an error like this
ORA-01008: not all variables bound
01008. 00000 - "not all variables bound"
*Cause:
*Action:
Vendor code 1008
Clearly there is nothing in the cause section. I need help please. Thanks in advance.
BUT I can succesfully run it from Sql plus command line utility as well as I can run it as a *.sql file. But It is not working in case of a report. Why is this happening?