ORA-7445[kkmwop] for DML with Huge In-List Values in the Where Condition (Doc ID 3013349.1)

Last updated on MAY 13, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms :
1. Errors can be seen starting with 11.2.0.3 database version, including 19c version.

2. The errors encountered may be:

The WHERE condition in the DELETE statement has a very large in list with 11466 bind variables in above example.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.