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.

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 for hfx642

Are your substitution variables populated?

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

Try this

SELECT *
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, networking, learning, and sharing knowledge.