hi am having this error in my procedure ,but when I test the table in my is working ok but when I put in procedure is giving this error
example
am getting error in sql like this,when I type hr. it even suggest/show the table exist but when I compile is giving error
select emname into p_employee from hr.employee
its ok when I run like this in my sql*plus
select emname from hr.employee