SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select column into variable issue when it is null

939696Jun 21 2012 — edited Jun 22 2012

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.

`

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 20 2012

Added on Jun 21 2012

10 comments

5,157 views