Event Alerts Fail With APP-ALR-04110: Oracle Alert Found An Invalid Number Of Bind Variables In The SQL Statement
(Doc ID 948037.1)
Last updated on FEBRUARY 12, 2019
Applies to:Oracle Alert - Version 18.104.22.168 to 22.214.171.124 [Release 11.5]
Information in this document applies to any platform.
Periodic alerts are woking fine. After Oracle Alerts are configured using sendmail feature, but none of the event alerts seem to work.
When an event alert is triggered, no Email is send to the user. There is no entry in the /var/log/maillog file. No concurrent request being submitted too.
Tried to test the setup with, Diagnostics #3 - Event Alert. The concurrent request completes normally but no e-mail was sent.
After adding the ORG ID in the installations tab of Alert Details, the program ALR_DISTRIBUTION_LISTS (Check Event Alert) errors with:
select ... from ALR_DISTRIBUTION_LISTS where rowid=':0'
APP-ALR-04106: Please correct the user-defined SQL statement for this alert.
Steps To Reproduce:
Trigger any event alert.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document