Originally posted by: JayCh

I've recently encountered with a problem When executing an update operation on a table in a Unicode Oracle instance containing a 'CHAR' column.

The error looks like below.The 'CHAR' column was of type "char(1 char)". When tried to update this column with value "Y", this was being inserted as "Y   ", which is causing the error. The data language is "Native" in the type tree for this column.

Error returned by OCIStmtExecute, errcode=12899
ORA-12899: value too large for column "SUPPORT"."TEST6"."COL2" (actual: 4, maximum: 1)

 I found the below solution from IBM, but I couldn't figure how to set envirnment variable. Need advice on how to do this.

Help much appreciated

Thanks,

Jay

Originally posted by: paul.brett

From the Control Panel / System applet, choose 'Advanced systems settings'.

{See screenshot1}

From the Advanced tab, click the Environment variables button.

{See screenshot2}

Use the New button in the System variable section, and create your entry.

{See screenshot3}

Thank-you.

Paul.

Follow me on Twitter

Originally posted by: JayCh

Thanks Much Paul!

Now my map updates the column without any problem

Best Regards,

Jay