https://communities.sas.com/t5/SAS-Programming/How-to-read-the-contents-of-a-BLOB-file-stored-on-Oracle/m-p/836808#M330862 <P>Use passthru SQL so you can uses ORACLE commands to parse the BLOB into strings of 32767 characters or less.</P> <P>&nbsp;</P> Tue, 04 Oct 2022 20:36:57 GMT Tom 2022-10-04T20:36:57Z https://communities.sas.com/t5/SAS-Programming/How-to-read-the-contents-of-a-BLOB-file-stored-on-Oracle/m-p/836804#M330858 <P>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.&nbsp;</P> Tue, 04 Oct 2022 20:22:36 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-the-contents-of-a-BLOB-file-stored-on-Oracle/m-p/836804#M330858 Badri_M 2022-10-04T20:22:36Z https://communities.sas.com/t5/SAS-Programming/How-to-read-the-contents-of-a-BLOB-file-stored-on-Oracle/m-p/836808#M330862 <P>Use passthru SQL so you can uses ORACLE commands to parse the BLOB into strings of 32767 characters or less.</P> <P>&nbsp;</P> Tue, 04 Oct 2022 20:36:57 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-the-contents-of-a-BLOB-file-stored-on-Oracle/m-p/836808#M330862 Tom 2022-10-04T20:36:57Z https://communities.sas.com/t5/SAS-Programming/How-to-read-the-contents-of-a-BLOB-file-stored-on-Oracle/m-p/836906#M330912 As Tom said using to_char() function of oracle to change it into a string before importing into sas. Wed, 05 Oct 2022 10:25:30 GMT https://communities.sas.com/t5/SAS-Programming/How-to-read-the-contents-of-a-BLOB-file-stored-on-Oracle/m-p/836906#M330912 Ksharp 2022-10-05T10:25:30Z