Euro Symbol not populating in Oracle

[Sainath.Srinivasan]

What is your NLS setting ?

Try writing the value into a sequential file and check.

[ArndW]

This is a common question resulting from NLS and incorrect settings. Most likely your Oracle environment variable NLS_LANG is not set correctly at runtime. What value do you have and what NLS setting does your Oracle instance have?

[rohanf]

In Datastage the NLS is set in dsenv as below:
export NLS_LANG=american_america.WE8ISO8859P15

In Oracle the Character set used is = "UTF - 8"

[ArndW]

typing in the Euro explicitly should be OK. What method are you using in your Oracle stage - insert/upsert or table load, that might be where the problem is creeping in.

[nitkuar]

Writing on behalf of Rohan:-
I had used below options:-

1:
Write Method : Load
Write Mode : Replace

Result: All records are loaded but without the Euro symbol. With below warning:-
Oracle_Enterprise_3,1: Invalid character(s) ([x20AC]) found converting Unicode string (code point(s): ROUNDING DISCOUNT ( [x20AC].81 )) to codepage ISO-8859-1, substituting.

2:
Write Method : Upsert
Upsert Order: Insert then Update
Upsert mode: user defined Update & Insert

Result: All records are rejected. Zero records loaded. Below is the warning:-
Oracle_Enterprise_3,1: Invalid character(s) ([x20AC]) found converting Unicode string (code point(s): ROUNDING DISCOUNT ( [x20AC].81 )) to codepage ISO-8859-1, substituting.

[rohanf]

I am still having this issue.
Can anybody please help.

Regards
Rohan

[ArndW]

Since the UNIX level NLS_LANG setting is correct, I would look into your ORACLE setting. From SqlPlus or the tool of your choice, execute "SELECT * FROM NLS_SESSION_PARAMETERS;" to see what your database is set up as.