My Oracle Support Banner

R12.2 Manage Queries - Query Exceeds Maximum Allowed Value (VARCHAR (4000, -127)) (Doc ID 1997787.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Advanced Collections - Version 12.2.4 and later
Information in this document applies to any platform.


After applying patch 19775976, when trying to add a Clob query, the page errors if the query exceeds 4000 characters.  Prior to the patch, the query could exceed 4000 characters.

Query exceeds the maximum allowed value (VARCHAR (4000, -127))

Steps to Reproduce:

Responsibility: Collections Administrator
: Manage Queries

  1. Check the Clob query, and try to save a clob > 4000 characters


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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