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?


Recommended Answers

All 4 Replies

in which tool ?

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

Member Avatar

Are your substitution variables populated?

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

Try this

FROM employees
WHERE emp_id= :employee_num;

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.