APEX

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!

Problem with APEX 4.1, DBLink and NLS_LANG

Mburgos.arOct 20 2011 — edited Oct 24 2011

Hi,

I'm getting an error:

"ORA-12705: Invalid or unknown NLS parameter value specified"

When accesing data stored in another database from APEX through a DBLink

I'm using Application Express 4.1 on Oracle Database 11g XE

I have an application which uses dblink to access data on an Oracle 9i database.

NLS_LANG in 11g database: SPANISH_SPAIN.AL32UTF8
NLS_LANG in 9i database: SPANISH_SPAIN.WE8ISO8859P1

I changed the 11g NLS_LANG value to SPANISH_SPAIN.WE8ISO8859P1 but nothing happens.

What can I do?

Thanks!

This post has been answered by Patrick Wolf-Oracle on Oct 24 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2011

Added on Oct 20 2011

#11g, #9i, #apex, #apex-discussions, #error

4 comments

817 views