gustafn
committed
on 13 Feb 22
Fixes for Oracle 19c for membership and composition triggers

Warning: Trigger created with compilation errors.
Errors for TRIGGER MEMBERSHI… Show more
Fixes for Oracle 19c for membership and composition triggers

Warning: Trigger created with compilation errors.

Errors for TRIGGER MEMBERSHIP_RELS_IN_TR:

LINE/COL ERROR

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

14/3     PL/SQL: SQL Statement ignored

16/3     PL/SQL: ORA-00947: not enough values

32/3     PL/SQL: Statement ignored

32/6     PLS-00201: identifier 'V_COMPOSABLE_P' must be declared

Trigger created.

No errors.

Warning: Trigger created with compilation errors.

Errors for TRIGGER COMPOSITION_RELS_IN_TR:

LINE/COL ERROR

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

72/21    PL/SQL: SQL Statement ignored

72/48    PL/SQL: ORA-00918: column ambiguously defined

83/7     PL/SQL: Statement ignored

83/47    PLS-00364: loop index variable 'MEMBERS' use is invalid

86/5     PL/SQL: SQL Statement ignored

91/6     PL/SQL: ORA-00918: column ambiguously defined

Trigger created.

No errors.

Show less