There's a problem when you do a query on a table that has a column with a custom type based on nvarchar2. This combination causes weird output.
Code to simulate the error:
CREATE OR REPLACE TYPE T_CUST_TYPE AS OBJECT (
value nvarchar2(300));
create table W_ITEM
(
ITEM_DESC T_CUST_TYPE
);
insert into W_ITEM (ITEM_DESC) values (T_CUST_TYPE('33'));
select * from W_ITEM; --outputs a chinese/japanese character
select ITEM_DESC.VALUE from W_ITEM; -- works ok
Code to simulate the error:
CREATE OR REPLACE TYPE T_CUST_TYPE AS OBJECT (
value nvarchar2(300));
create table W_ITEM
(
ITEM_DESC T_CUST_TYPE
);
insert into W_ITEM (ITEM_DESC) values (T_CUST_TYPE('33'));
select * from W_ITEM; --outputs a chinese/japanese character
select ITEM_DESC.VALUE from W_ITEM; -- works ok
