BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
antonio-domenic
Community Trekker

extract RAW datatype from Oracle database table

I have a problem when I try to extract data from a column in Oracle table that is RAW type. The result after Execute SQL() is a table with a numeric column but each cells show the dot '.' value. Of course, using Oracle SQL Developer I am able to extract the data. Is it possible to find a solution for this?

Thanks in advance

0 Kudos
1 REPLY 1
guillaumebugnon
Community Trekker

Re: extract RAW datatype from Oracle database table

Hi,

Are you using QueryBuilder or query into jsl.
In the second way, maybe you can try to convert RAW into NUMBER (to_number).
0 Kudos