How to read the contents of a BLOB file stored on Oracle Database

[Badri_M]

I am trying to access the contents of blob files stored on an oracle database. How would I go about reading the blob files contents in SAS so that I may perform operations on it. 

[Tom · Accepted solution]

Use passthru SQL so you can uses ORACLE commands to parse the BLOB into strings of 32767 characters or less.

[Ksharp]

As Tom said using to_char() function of oracle to change it into a string before importing into sas.