How to save a BLOB on my PC

[albaalbetti]

Hi,
I have to save the content of a BLOB on my PC.
If I execute
SELECT COLUMN_LOB
FROM TABLE;
I get
COLUMN_LOB

Without opening the BLOB, how can I directly save it on my PC?
Thanks!

 

[Marco Kalter]

You will need to invoke the Large Data Editor to save the contents to a file. This cannot be accomplished directly.

 

[albaalbetti]

Thanks, but how can I open the Large Data Editor?

 

[Marco Kalter]

Click on the cell button [...] to the right.

 

[albaalbetti]

Thanks for the advice.
I've tried to clicl on cell (where I see ...) but after a while I get a "Out of memory" message. Could it be a problem of my PC? The blob is 180Mb

 

[albaalbetti]

Thanks for the advice.
I've tried to click on cell (where I see ...) but after a while I get a "Out of memory" message. Could it be a problem of my PC? The blob is 180Mb
My Pl Sql Developer vers. is 8.0.4

 

[Marco Kalter]

Do you also get this with smaller BLOB values?

 

[albaalbetti]

No, with smaller BLOB values I can.
Take into account that on my PC for larger BLOB values, I can get the values by using TOAD. Only with large BLOB and only with Pl Slq Developer 8.0.4 I have problems