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.
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.
Jump to Postin which tool ?
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
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;
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.
You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed. It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post.