gustafn
committed
on 16 Feb 22
Fixes for Oracle 19c: fix syntax and handling of boolean values

This change fixes the following problems:

Errors for PACKAGE ACS_EVENT:
LI… Show more
Fixes for Oracle 19c: fix syntax and handling of boolean values

This change fixes the following problems:

Errors for PACKAGE ACS_EVENT:

LINE/COL ERROR

-------- -----------------------------------------------------------------

3/5      PL/SQL: Declaration ignored

43/39    PLS-00302: component 'LOCATIONREDIRECT_TO_REL_LINK_P' must be

         declared

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY ACS_EVENT:

LINE/COL ERROR

-------- -----------------------------------------------------------------

19/2     PLS-00103: Encountered the symbol "RELATED_LINK_URL" when

         expecting one of the following:

         ) , * & = - + < / > at in is mod remainder not rem

         <an exponent (**)> <> or != or ~= >= <= <> and or like like2

         like4 likec between || multiset member submultiset

         The symbol "," was substituted for "RELATED_LINK_URL" to

         continue.

296/29   PLS-00103: Encountered the symbol "(" when expecting one of the

         following:

         mod <an identifier> <a double-quoted delimited-identifier>

LINE/COL ERROR

-------- -----------------------------------------------------------------

         <a bind variable> continue current sql execute forall merge

         pipe purge json_exists json_value json_query json_object

         json_array

Show less