Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Retrieve .msg file stored in oracle clob data into local directory

User_I94XLMar 18 2022

Hi
I am trying to retrieve .msg (outlook file) stored in oracle database against a clob_data_type
I am using Oracle 11g - I don't have a option to create a oracle Form - I am trying to get this using SQL script
Also, tried https://orclqa.com/oracle-pl-sql-download-blob-file-to-disk/ by changing the datatype frpm blob to clob - everything runs okay but file is not stored in local machine
Not sure what to do - Any pointer would be helpful
Thanks In Advance

Comments
Post Details
Added on Mar 18 2022
3 comments
478 views