4 Replies Latest reply: Oct 17, 2013 3:17 PM by TexasApexDeveloper RSS

    no data found - exception handling


      I am calling a page with the following URL (from another report):




      but sometime I get this error:


      ORA-01403: no data found   Error    Unable to fetch row.



      Obviously when there is no record with the recieved key, I get the error.


      Now, I am looking to see if I can check the value prior to opening the page and show a send a simple msg to screen that the record does not exist.


      Is it possible to utilize a trigger (like "On Load") or something like that to check if the record exists, then either open or send a msg...


      Thanks very much in advance,