Hi,
I am working in oracle 10g and in my procedure i am using the following statement .
seelct name, age into v_emp,v_age from employee where empno = p_empno.
My issue is if there is no data availabe for name or age the query will return empty row and i am getting "no data found" exeception. So please help me to avoid this eception to execute the procedure sucessfully. Whatcould be the remedy.