nls_length_semantics

Hi,

I've created a DBlink on Oracle database 9.2.0.4 to access a remote Oracle database 9.2.0.7 but when I try to select a table the following message is displayed

SQL> select * from owner.table1@ORCL;
select * from owner.table1@ORCL
*
ERROR at line 1:
ORA-00096: invalid value BYTE for parameter nls_length_semantics, must be from
among !?,
ORA-02063: preceding line from ORCLDB01

Please let me know what can I do to fix this issue. :confused:

Hi,

You can try ALTER SESSION SET NLS_LENGTH_SEMANTICS='CHAR';

and try to execute.

I tried your recommendation but I recieved this message:
"SQL> alter session set nls_length_semantics='CHAR';
ERROR:
ORA-00096: invalid value CHAR for parameter nls_length_semantics, must be from
among !?,
"

Hi,
Could you post
show parameter NLS_LENGTH_SEMANTICS;

Hi kamkan,

Here is the value for the parmeter:

SQL> show parameters nls_length_semantics

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_length_semantics string BYTE
SQL>

Thanks in advance for your help.

Hi,
Is this issue specific to single table? If yes, could you describe the table and post the datatypes of the columns?
Altering NLS_LENGTH_SEMANTICS will be helpful only if you create any new object. This may not be helpful in this case.
Pls post the database characterset and national character set of the remote database.

This issue happen with any table. The character set for both databases is:
AL16UTF16