Parameters order is not predictable leading to ORA-24816 when inserting a row into a table with Unlimited string column and another (limited) string column

Description

Oracle requires that LOB / LONG parameters should come last in the INSERT / UPDATE statements, or at least not before any VARCHAR parameters.

Unfortunately, AO ignores this fact and EntityManager.create() randomly orders the inserted parameters because they are collected via a HashSet. Which may lead to BLOB column parameter coming before a VARCHAR column parameter, which then produces this error:

Environment

Oracle DB

Testing Notes

Add notes...

Assignee

Unassigned

Reporter

Igor Sereda [ALM Works]

Labels

None

Add-on Type

None

Team

None

CC

None

Risk factor

None

QA Kickoff Status

None

QA Demo Status

None

Priority

Major
Configure