we're testing Release Patch 4.2.2.00.11 after upgrading from v. 4.02. to 4.22 ( Database server is22.214.171.124 on Linux x86_64) and our Apex Developer /Tester runs into an error when applying a multirow update in a tabular form
The error can be located in the internal Apex routine where a sequence no ist generated :
- the update statement itself is correct and contains the schemaowner.object notation but the generated SQL for the ApplyMRU uses a wrong syntax where the schema owner is missing; The cursor is invalidated .
There are also other Tabular Forms where the schema owner is not missing but wrongly quoted which results in ORA-00972 identifier too long (then the string looks like "HI_FRM.SEQ_BMT_TEMP_KONSTITUENT").
When reading the Readme to Patchset Patch 4.2.2.00.11 one would assume the Bug "14775149 Tabular Form Wizard: Parse Err: ORA-00972: identifier is too long" had been fixed but it looks like it's still there.