Skip to Main Content
Forums

SQL & PL/SQL

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!

Extract file data from blob

user644062Feb 9 2017 — edited Feb 13 2017

Hello ,

I have a table with BLOB type and It has file attachments from JDE Source.

Name Of the Table: JDE_BLOB

Blob Column : GXTFT

I also attached some images of the attached text file from JDE Source and also the content of the text file.So basically this text file is stored in the blob field.

JDE Screenshot for a record.PNG

content of the text file.PNG
This post has been answered by odie_63 on Feb 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2017
Added on Feb 9 2017
25 comments
3,918 views