Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Logon Trigger to alter session NLS_CHARACTERSET

SanyiApr 24 2013 — edited Apr 25 2013
Hi,
I'd like to call a PL/SQL stored procedure from an IBM MessageBroker ESQL code.
My problem is that character encoding does not match between the two systems. NLS_CHARACTERSET = EE8ISO8859P2 ,NLS_NCHAR_CHARACTERSET = UTF8 but message broker character set = AL32UTF8. The accents do not appear well in the database.
My question:
Can I solve this problem with a logon trigger which alters session that the NLS_CHARACTERSET be AL32UTF8?

Help me, please.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2013
Added on Apr 24 2013
#database-key-features, #globalization-support
6 comments
8,915 views