file - Trying to Move images in PLSQL - Stack Overflow

admin管理员组

文章数量:1300053

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?

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?

• image
• file
• plsql
• copy
• jpeg

Share Improve this question Follow edited Feb 17 at 13:36 vswindell asked Feb 11 at 20:31 vswindellvswindell 4111 silver badge66 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

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

本文标签： fileTrying to Move images in PLSQLStack Overflow