Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 17.2 not exporting RAW fields correctly

Brian BiggsAug 6 2017 — edited Aug 18 2017

Upgraded to SQL Developer 17.2 on Windows this past week. Exporting of RAW columns appears to now be broken from 4.1.5.21.78.

In 4.1.5.21.78, the query runs fine (just a straight SELECT column FROM table), and exporting to a pipe delimited file without quotes yields the RAW values as I see them in the query result (32-character GUID values, numbers and letters).

In 17.2, the query also runs fine, but the same export shows the RAW field as a garbled string of 9-10 characters, e.g. [B@bbac16, which is not what is displayed in the query result (a full 32 characters).

I was able to workaround the issue by using CAST(column AS VARCHAR2(100)) and THAT exports as expected to a text file.

I just wanted to report this as a possible bug in 17.2 and the way it handles exporting RAW columns to text files.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 15 2017
Added on Aug 6 2017
9 comments
1,372 views