Skip to Main Content

APEX

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!

Error Handling Function not being executed

jaramillNov 23 2024

Environment:

  1. O/S : Windows version 11
  2. DB : Oracle version 19c
  3. APEX: Version 21.2

I'm testing out Insum Corps version of the Oracle APEX error handling example below:

https://docs.oracle.com/en/database/oracle/application-express/21.2/aeapi/Example-of-an-Error-Handling-Function.html

And I've created the package spec/body in the database, gave it a public synonym, granted execute privileges to it.

Then referenced it in the application properties

Then in my application I intentionally code an insert statement to insert a sequence ID that's already in the table causing a primary key violation. Then run the application and I get the yellow windo popped up in the top right corner:

So I then proceed to APEX builder and go to Shared Components → Globalization section, and click on the “Text Messages” link

And search and no messages found

Am I doing something wrong or missing something?

Thanks,

Comments
Post Details
Added on Nov 23 2024
15 comments
1,019 views