SQL*Plus (MOSC)

MOSC Banner

Downloading a blob from the database

edited Aug 5, 2022 1:48PM in SQL*Plus (MOSC) 1 commentAnswered ✓

Dear Experts,

Oracle 19C.

I'm having trouble reading a blob created by another system. The blob is saved to an oracle table. I don't have the source code for this, but I know that my example should be a spreadsheet xlsx. I have the original spreadsheet.

When I download the file It doesn't look like a blob to me, if I open it in an editor it looks very much in character format. If I view the column in SQL developer, it looks very much in character format.


First few line of the character file.

Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center