Precompilers and OCI (MOSC)

MOSC Banner

ORA-01882: timezone region not found

edited Sep 2, 2024 7:01AM in Precompilers and OCI (MOSC) Question

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,

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