SqlTalk/Oracle (11 & 12)/Raw data type

[bph]

In Sqltalk from TD3.1, we could select all columns from V$session or v$lock :

Code: Select all

select ADDR,SID from V$LOCK;

ADDR        SID
==== ===========
‘tU°          3
‘tV$          3
‘tV˜          3
...

but if i do the same request in sqltalk 10.0 from TD6.1 or TD6.3

Code: Select all

Error: 10446 SQL UBC Unicode conversion failed.

columns KADDR or ADDR are preventing the select to finish :

Code: Select all

select    COLUMN_NAME, DATA_TYPE 
from    ALL_TAB_COLUMNS where TABLE_NAME = 'V_$LOCK' order by DATA_TYPE;

COLUMN_NAME             DATA_TYPE
============================== ===============================================
BLOCK                NUMBER
CTIME                NUMBER
REQUEST              NUMBER
LMODE                NUMBER
ID2                NUMBER
SID                NUMBER
ID1                NUMBER
KADDR                RAW
ADDR                RAW
TYPE                VARCHAR2

--10 ROWS SELECTED  IN 0.02 SECONDS

this kind of column are often present in Oracle views :

Code: Select all

select    count(*)
from    ALL_TAB_COLUMNS where DATA_TYPE = 'RAW';

   COUNT(*)
===========
       2918

-- 1 ROW SELECTED IN 2.96 SECONDS

It seems that Sqltalk try to apply Char translation to this binary type, and fail.

Oracle Sqlplus or Oracle Sql Developer show them as hexadecimal number's.