Wfmlrdbg.sql

Use wfmlrdbg.sql to display debugging information for a notification that you can use to check the status of the notification or investigate errors. This script creates an output file named wfmlrdbg<nid>.html, where <nid> is the notification ID (NID).

Use the script as follows:

sqlplus <user> @wfmlrdbg <nid> 
Enter password: <password>

Replace <nid> with the notification ID for the notification.

Note: You can also obtain this information by running the Mailer Diagnostic Test in Oracle Diagnostics Framework. See: Mailer Diagnostic Test.