Change NLS_LANG Character Set (NT Oracle)

From: Allen <allen_at_ms15.hinet.net>
Date: Mon, 11 Oct 1999 22:21:09 +0800
Message-ID: <7tsrqe$ngm@netnews.hinet.net>

Is Anyone can Help ?

I have changed NT Oracle NLS_LANGUAGE Character Set in "PROPS$", and execute all the Sql Scripts in rdbms80\admin, (CATPROC.sql).

Everything seems to be OK, but when I executed a Query function in a Sql Statement,

select get_desc(Table1.Field_name) from Table1; I got the following error message:

ORA-06553: PLS-561: character set mismatch on value for parameter 'Field_name'

(I can not find any message in Oracle error message listing)

but if I changed the Sql Statement:

select
get_desc(CONVERT(Table1.Field_name,'we8iso8859p1','we8iso8859p1')) from Table1;
I got the correct Result, just as I changed Character Set before.

Does anyone meet the same problem (change NLS character set) like what I have done!

Need your Help, Thanks a lots!

Best Regard,
Allen Received on Mon Oct 11 1999 - 09:21:09 CDT