BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
antonio-domenic

Community Trekker

Joined:

Feb 19, 2016

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

1 REPLY 1
guillaumebugnon

Community Trekker

Joined:

Apr 7, 2015

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).