OraFAQ Forum: SQL & PL/SQL » How to download a BLOB field data to local storage (merged)

Home » SQL & PL/SQL » SQL & PL/SQL » How to download a BLOB field data to local storage (merged) (Oracle form 12c RDS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to download a BLOB field data to local storage (merged) [message #679035]

Thu, 30 January 2020 01:26

Shiv93
Messages: 34
Registered: September 2019

Member

Hi All,

I have a blob field with a PDF stored from a web-service response. Is it possible to download the blob field data into my local machine .

Note: I don't have a unix server for storing the files as im using 12c RDS. Please let me know if there is any possibility option to download the BLOB field.

Regards,
Siva

Report message to a moderator

How to download a BLOB field data to local storage [message #679036 is a reply to message #679035]

Thu, 30 January 2020 01:27

Shiv93
Messages: 34
Registered: September 2019

Member

Report message to a moderator

Re: How to download a BLOB field data to local storage (merged) [message #679037 is a reply to message #679035]

Thu, 30 January 2020 04:08

John Watson
Messages: 8738
Registered: January 2010
Location: Global Village

Senior Member

Why can you not store the files in the RDS server? Create the directory with rdsadmin.rdsadmin_util.create_directory and then there are various utilities for copying stuff in and out.

Report message to a moderator

Previous Topic:	Writing from Ref cursor to UTIL file
Next Topic:	Calling webservice from plsql package (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 14 10:32:31 CDT 2022