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!

bfilename releated issue

MADHAN KUMAR KFeb 16 2016 — edited Feb 16 2016

Dear Team,

i used the below command

v_in_file := bfilename(upper(p_directory_name),p_file_name);

am passing the directory name and file without file extension i got the error message as

ORA-22288: file or LOB operation FILEOPEN failed

bt same if pasing the file name with extension it will we working fine.

Can any one plz tel me y we have to pass the file name with extension.

Thank in advance.

This post has been answered by Paulzip on Feb 16 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2016

Added on Feb 16 2016

5 comments

349 views