Getting error "ORA-22926" when importing test definitions with big CDATA blocks (4334195)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Getting error "ORA-22926" when importing test definitions with big CDATA blocks
Description

Getting error "ORA-22926: specified trim length is greater than current LOB value's length" when importing test definitions with big CDATA blocks.
Those tests definitions were exported for other installation of Code Tester and ara valis and working there.
Cause

ORA-22926 exception is a known exception in Oracle 11 databases. It is raised because of some incorrect working with LOB objects. Particularly in this case the Oracle REPLACE function works incorrectly for big LOB values.
The solution is to use other Oracle functions instead of the REPLACE one.
Resolution

WORKAROUND

None

STATUS

Waiting for fix in a future release of Code Tester for Oracle
Defect ID

CTO-183

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title