ORA-08177: can't serialize access for this transaction

[former_member192181]

Hi All,

Iam Using JDBC Sender Adapter where using pipelined functions to fetch data and using custom module to update the records which got fetched.

When Iam trying to fetch more than 1000 records, Iam facing the issue as ORA-08177: can't serialize access for this transaction.

The Java Module is throwing error as ORA-08177: can't serialize access for this transaction.

Please advice on this.

Thanks and Regards,

Lalitha

[marksmyth]

Hello Lalitha,

Check note 831162 FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 JDBC Adapter

-> 21. ORACLE: ORA-08177: can't serialize access for this transaction

Regards

Mark

[former_member192181]

Hi Mark,

I have already tried which is mentioned in the Note. But it is not working.

Thanks,

Lalitha

[former_member192181]

Iam not using advanced mode.

[Former Member]

Hi

Please use that and see if works or not.

[former_member192181]

No.. It is throwing the same error.

[Former Member]

Hi

Set the isolation level to "Read Committed".

Check this tread for more details