Working with Oracle BLOB

[DanK]

I tried the same statement directly in Oracle SQL Developer and got the same ORA-00932 error. I have no clue on how to get around this.

[DanK]

-----Original Message-----
From: SAS Technical Support [mailto:support@sas.com]
Sent: Thursday, May 21, 2009 1:18 PM
To: Kanze, Daniel R (GE Money)
Subject: [SAS 7610215082] Reading Oracle BLOB

Dan,
Yes, I will open a defect requesting and enhancement for a future release.

Regards,
Donna
SAS Technical Support

[ChrisNZ]

You might need to convert the blob to a string (if oracle can do this) as substr probably does not take blobs as argument.

[DanK]

I tried to_char(blob) in an Oracle select but that did not solve the problem. substr(blob,1,32000) works in SAS after retrieving the data from Oracle but select substr(blob,1,3200) as myblob will not work in a select statement.

Someone, somewhere has delt with this issue and solved it.

Thanks
Dan

[LinusH]

I suggest that you post you problem on a Oracle forum instead, since it's quite clear this could not be solved with any SAS specific tool. Probably both suggested ways are feasible (substr and export to text-file).

/Linus

[ChrisNZ]

So select substr(to_char(blob),1,32000) sent to oracle fails?

Have you tried exporting to a macro variable (which accepts 64k) using select into?

It might work or not, depending on whether sas store the value in a string or not before filling the macro variable.

No SQL passthru allowed here obviously.

[Beo]

Hello,

I am trying to import a Blob with dimension around 200KB using sas. Did you find the solution for your problem?

Best regards

Max Beo