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

    no data found - exception handling

    Mehr

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

       

      /apex/f?p=119:76:1413455596761702::NO::P76_CODE:ABC

       

      but sometime I get this error:

       

      ORA-01403: no data found

      http://192.168.1.52:8080/i/error.gif   Error    Unable to fetch row.

      OK

       

      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,

      Mehr