Skip to Main Content

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!

Utilizing UTL_FILE.FCOPY for actual pdf file

738e1767-f4f1-49c5-94de-b44817b33604Sep 16 2019 — edited Sep 17 2019

Hi I have an actual pdf file that is stored in the local oracle server. I am experimenting with utilizing UTL_FILE.FCOPY to try to copy a pdf file to a different directory within the same server. It does the actual process of copying the file however, when it is opened it has mostly blank pages.

begin

UTL_FILE.FCOPY ( 'EPAPER_UPS_2019' , --THIS IS A ORACLE DIRECTORY

                             'Test\_john.PDF', --FILE NAME

                             'PATHWAYS\_2267' , --THIS IS A ORACLE DIRECTORY

                             'Test\_john.PDF'); --DESTINATION FILE

end;

actual file vs what is copied

pastedImage_7.png vs. pastedImage_6.png

Comments
Post Details
Added on Sep 16 2019
2 comments
728 views