My Oracle Support Banner

OCI Application Fails With ORA-01483/ORA-01461 When Inserting VARCHAR2 Field From 12.2/18c Database Using Database Link To Lower Database Version. (Doc ID 2309285.1)

Last updated on JULY 03, 2023

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


An OCI application connected to a 12.2.0.x or 18c database fails with any of the below error when inserting a VARCHAR2 column through a database link pointing to a lower database version.
This error happens only when:

1) The VARCHAR2/CHAR bind is followed by a NUMBER bind or another VARCHAR2/CHAR bind.
2) The OCI environment is initialized in OCI_UTF16ID mode.
3) The length of the bind value is > 2k.

For example, consider a table with below structure:



Upgraded the database to or 18c, or its a new application. 


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

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