ORA-01882: timezone region not found
Create table single_1 (c1 timestamp with time zone);
Sample code to insert timestamp with timezone. (which is attached to the case.)
Build the code and execute the executable, then you would be observing that the program will throw ORA-01882: timezone region not found error.
However, when OCIEnvNlsCreate API is executed without OCI_UTF16ID as shown below, then program would insert the record successfully into the table.
So whenever OCI_UTF16ID is passed to the OCIEnvNlsCreate API, does it set "territory", "timezone" internally and hence we are observing ORA-01882: timezone region not found error?
if (OCIEnvNlsCreate(&envhp, OCI_DEFAULT, NULL, NULL, NULL, NULL, 0, NULL,