My Oracle Support Banner

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 to [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:

APP-ALR-04110: Oracle Alert found an invalid number of bind variables in the SQL Statement:
              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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.