BookmarkSubscribeRSS Feed
DanK
Calcite | Level 5
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
Calcite | Level 5
-----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
Tourmaline | Level 20
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
Calcite | Level 5
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
Tourmaline | Level 20
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
Data never sleeps
ChrisNZ
Tourmaline | Level 20
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
Calcite | Level 5 Beo
Calcite | Level 5

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 21 replies
  • 8504 views
  • 0 likes
  • 8 in conversation