Trying to Move images in PL/SQL

Question

I'm trying to write a PL/SQL program to COPY a JPG files from one directory to another. The file names themselves are the id's in a table that I fetch and make a variable photo_file_name := lower(id_wk || '.jpg');

The images exist in the mapped network Directory_object PHOTO_DIR (verified) mapped to vc_photo_dir:

I have a test image (photo_file_name) let's say called 1000001.jpg in the PHOTO_DIR I can see it..it's there

If I use utl_file.fgetattr(vc_photo_dir, photo_file_name, v_exists, v_length, v_blocksize);

and check v_exists it is always FALSE

if I dump vc_photo_dir and photo_file_name

any clue why the script can't find the file?

vswindell · Accepted Answer · 2025-02-17 13:38:34Z

0

the problem was that I didn't have permission to READ the photo directory from Atomic UC4 (which was running the script)

answered Feb 17 at 13:38

vswindell

411 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to Move images in PL/SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related