Troubleshooting > ThirdPartyIssues > Resolving ORACLE_ERROR, INERR, and Unexpected Behavior When Extracting CLOB Data from Oracle Database Sources

Resolving ORACLE_ERROR, INERR, and Unexpected Behavior When Extracting CLOB Data from Oracle Database Sources

Article #: Product: Version:

Summary

When running a task that extracts data from a Character Large Object (CLOB) column in an Oracle database table, you may receive error messages or experience other unexpected behavior.

The underlying problem is caused by Oracle known issue #7253302, which incorrectly reports data sizes for CLOB columns when the character set is variable width.

To resolve this issue, upgrade the Oracle client.

Symptom

When running a DMExpress task that extracts CLOB data from an Oracle database source, you may receive one or both of the following error messages:

(ORACLE_ERROR) ORA-03130: the buffer for the next piece to be fetched is required.

(INERR) an internal error has occurred (1 in SSTRPHDL)

Due to the nature of the Oracle bug, affected DMExpress tasks may also produce incorrect output or experience other unexpected errors besides those listed.

The problem only manifests when using a character set or NLS_LANG setting that is variable width, such as any variant of UTF-8 or Shift JIS.

Resolution

Upgrading the affected Oracle client fixes this issue. Several upgrade paths are available from Oracle.

To resolve the issue, upgrade the Oracle client to any of the following versions:

Additional Information

For additional information, see Oracle known issue #7253302.

This article was originally published as KB article 46154.

Last updated: