SQL & PL/SQL

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!

Export/Import BLOBs into/from Textfile

Martin1Jul 23 2020 — edited Jul 24 2020

Hi,

i want to export BLOBs via utl_raw.cast_to_varchar2 and .cast_to_raw into a textfile. Afterwards i want to import the textfile as the APEX procedure wwv_flow_api.varchar2_to_blob it does. The idea is that i can export BLOBs on one database and import the BLOBs on another database via textfile. Has somebody an algorithm in PL/SQL code of the APEX procedure wwv_flow_api.varchar2_to_blob?

Many thanks in advance.

Regards,

Martin

Added on Jul 23 2020

8 comments

662 views