CODEWITHSUNDEEP
imagefileplsqlcopyjpeg
vswindell
vswindell

Reputation: 41

Trying to Move images in PL/SQL

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?

Upvotes: 0

Views: 21

Answers (1)

vswindell
vswindell

Reputation: 41

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

Upvotes: 0

Related Questions