How to fix the Oracle error ORA-26912: not allowed to invoke ‘string’ while in committed data-only mode?

In this post, you’ll learn more about the Oracle ErrorORA-26912: not allowed to invoke ‘string’ while in committed data-only mode with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-26912: not allowed to invoke ‘string’ while in committed data-only mode

Reason for the Error ORA-26912: not allowed to invoke ‘string’ while in committed data-only mode

An attempt was made to call the specified API while the attached XStream server was in committed data-only mode.

How to fix the Error ORA-26912: not allowed to invoke ‘string’ while in committed data-only mode ?

You can fix this error in Oracle by following the below steps

Perform one of the following: 1) If the invalid call is OCIXStreamOutProcessedLWMSet2, then change it to OCIXStreamOutProcessedLWMSet or pass a null oldest_position to OCIXStreamOutProcessedLWMSet2 call. 2) If the invalid call is OCIXStreamInProcessedLWMGet2, then change it to OCIXStreamInProcessedLWMGet or pass a null oldest_position to OCIXStreamInProcessedLWMGet2 call.