This discussion is archived
2 Replies Latest reply: Oct 12, 2012 4:42 AM by 962528 RSS

Continue processing after raise_application-error

962528 Newbie
Currently Being Moderated
Hi..
I a newbie to Oracle Apex. I Have a Problem that, I am undergoing some process in my application.
That fetches 'N' no.of Rows using cursor, then each rows are processed using the loop condition & its working fine.
But my problem is, My all process is working fine in the If condition, but i have to give a error message if the IF statement fails.

For Example:

loop
//some code
if x=0 then
//some process
else
raise_application_error(-20101,'Error Message');
end if;
//some code
end loop;

Actually, if one single row is fetched then its working fine. But in case if multiple rows are fetched where it contains

row1-->execute if statement,
row2-->execute if statement,
row3-->execut if-else statement,
row4-->execut if statement

if these rows are under process, then first two rows gets into if statement, but when "row3" fails if statement & raise the error the Entire application is terminated.
But I need the Application to Run continously until i Fetch all the rows.
Please help me how to do this issue..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points