Skip to Main Content

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!

procedure when no data found

755232Oct 14 2010 — edited Oct 15 2010
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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 12 2010
Added on Oct 14 2010
9 comments
2,364 views