CODEWITHSUNDEEP
oracle-apexoracle-apex-5
user7285351
user7285351

Reputation: 67

How to change error message in apex5.0

In apex5.0, I have a page Item Ref_no define as number and a dynamic action associated with it that fill other Page Items.

when entered an incorrect ID getting below error message: Ajax call returned server error ORA-01403: no data found for Execute PL/SQL Code.

Is there a way to customise this error to 'Enter Correct Reference'

Upvotes: 0

Views: 1181

Answers (2)

hisnameismyname2
hisnameismyname2

Reputation: 387

It's hard to say without seeing the pl/sql, or log, but it seems as though you need to add some error handling within that code.

E.g. 

Declare
   l_temp number;
Begin
   SELECT 1
       INTO l_temp
      FROM dual
    WHERE 1 = 0;
     EXCEPTION
        WHEN NO_DATA_FOUND THEN
           RAISE_APPLICATION_ERROR(-20000, 'Enter Correct Reference');
End;

Oracle doc on error handling

Upvotes: 1

Boris Serafimov
Boris Serafimov

Reputation: 635

On the process you have Error section when you can put text if operation fail. In case you try to put data in report you have section No Data Found in region atributes.

Upvotes: 0

Related Questions