substitution variable

[bangla]

Hi,

I typed the below code in oracle 10g express edition.

SELECT emp_id, last_name, salary, dept_id
FROM employees
WHERE emp_id = &employee_num

I get an error; ORA-01008: not all variables bound

Can you pls help?

Thanks.

[debasisdas]

in which tool ?

[irsha]

when i run the query
select * from labours_ir
where manager_id=&mgr_num
order by &col_order
there is an error not all variables bound
in oracle 10g express edition tools sql commands

Are your substitution variables populated?

[Swords]

& is supported only in sql plus and not in oracle EE.
Instead use :

Try this

SELECT *
FROM employees
WHERE emp_id= :employee_num;