Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Question about max_string_size in Oracle 19c with client 12.1

edited May 20, 2020 12:45PM in Database Install/Upgrade/Opatch (MOSC) 6 commentsAnswered ✓

Our customer recently upgraded their Oracle DB server from 12c Enterprise Edition 12.1.0.2.0 to 19c Enterprise Edition Release 19.0.0.0.0 - Production 19.6.0.0.0.
Customer claims that they do not use CDB/PDB or RAC.

Customer uses Oracle client v12.1.0.2.0. The customer claims their MAX_STRING_SIZE is STANDARD.

However, when our application calls OraOCIAttrGet() with attrtype type of OCI_ATTR_VARTYPE_MAXLEN_COMPAT, the call returns OCI_ATTR_MAXLEN_COMPAT_EXTENDED.

Customer INSISTS that their MAX_STRING_SIZE is STANDARD.

Is it possible that the use of Oracle client v12.1 with Oracle server v19.0 could cause an incorrect value for OCI_ATTR_MAXLEN_COMPAT to be returned?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center