when I execute a procedure like this execute itemincsvformat1aa('8826-64', :rc)
ORA-01001: invalid cursor
ORA-06512: at "TPLCP.ITEMINCSVFORMAT1AA", line 131
ORA-01403: no data found
ORA-06512: at line 1
I have this line in my procedure . where p_result is cursor name and I am working on oracle 10g
what I am trying to do is to show to the users that when they enter the parameter value and get no output then I want to show no output found message. thank you
EXCEPTION
WHEN NO_DATA_FOUND
THEN
DBMS_OUTPUT.put_line ('No Data Found');
CLOSE p_result;
END;