BLOB/CLOB/NCLOB operations in autoCommit mode can trigger Oracle errors
Oracle has an operational mode called "auto commit" which causes Oracle
to automatically commit work after each operation. Auto commit mode is
established by setting the associated GsOracleParameter instvar autoCommit
to true.
This causes problems with GemConnect operations using BLOBS/CLOBS/NCLOBS,
which do a series of Oracle OCI calls that *must not* have an intervening
commit between them in order to work properly.
Typical error is a GsRdbError readError by Oracle error ORA-01002: fetch
out of sequence.
Appearance from topaz:
ERROR 8 , a GsRdbError occurred (error 8), reason:readError, An error was
encountered while reading relational data, stream: nil (GsRdbError)
Workaround
Set GsOracleParameter autoCommit to false.
Last updated: 10/2/23