My Oracle Support Banner

ResultSetMetaData.getPrecision and getColumnDisplaySize Return Values That Are Different From the Maximum Size of the Column in Certain Conditions (Doc ID 2926404.1)

Last updated on FEBRUARY 14, 2023

Applies to:

JDBC - Version 18.3 and later
Information in this document applies to any platform.

Goal

ResultSetMetaData.getPrecision and getColumnDisplaySize return incorrect values for VARCHAR2. However, under certain conditions like when using the VARCHAR2 column in a WHERE '=' and 'GROUP BY' clauses, they return the actual size of the column instead of the maximum size of the column. This issue does not happen when using WHERE '>' clause and 'GROUP BY'.

Why does this happen?

Solution

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
Goal
Solution
References


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