gustafn
committed
on 15 Feb 22
Fixes for Oracle 19c: replaced "limit" by the portable idiom "fetch ... rows only"

This fixes the following bug in Oracle installations:
: … Show more
Fixes for Oracle 19c: replaced "limit" by the portable idiom "fetch ... rows only"

This fixes the following bug in Oracle installations:

:    SQL:

:                select aml_email_id from acs_mail_lite_from_external

:                where processed_p <>'1'

:                and release_p <>'1'

:                order by priority

:                !>>>!limit :email_max_ct

:    nsoracle.c:1367:OracleSelect: error in `OCIStmtExecute ()': ORA-00933: SQL command not properly ended

Show less