My Oracle Support Banner

Basic OCI Program to Bind and Fetch Data when the Env is Created in Unicode (OCI_UTF16ID) Mode (Doc ID 1302061.1)

Last updated on JUNE 26, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


This program demonstrates a simple scalar fetch using OCI8 in unicode mode. It assumes all strings in the program are in the client NLS_LANG characterset and any strings returned by Oracle should be output in the client NLS_LANG characterset. Strings are converted between the NLS_LANG characterset and AL16UTF16 as appropriate by calls to OCINlsCharSetConvert.


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
 Sample Code
 Sample Output

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