I've run a script to test for the existence of those files (using
Toad). This was an effort to test whether those files were accessible.
DECLARE
--after creating the directory executed this script
--consistently getting "file does not exist" due to
v_file value of zero
v_file BFILE := BFILENAME('THE_FILE2','letterhead_hi.dot');
BEGIN
IF DBMS_LOB.FILEEXISTS (v_file) = 1 THEN
DBMS_OUTPUT.PUT_LINE ('File exists.');
ELSIF DBMS_LOB.FILEEXISTS (v_file) = 0 THEN
DBMS_OUTPUT.PUT_LINE ('File does not exist '
||DBMS_LOB.FILEEXISTS (v_file) );
ELSE
DBMS_OUTPUT.PUT_LINE ('Unable to test existence');
END IF;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('error happened on ! '||
dbms_lob.fileexists(v_file));
END;
The permissions issue has been ruled out already and there doesn't
appear to be much available on the subject. Not to mention a solution
that might be readily applied by an Oracle novice. Three of the files
are pdf's (training manuals) and the other is a letterhead template.
Re-checked the permissions and no reason for error found there. Any
help is greatly appreciated.
Received on Thu Jan 05 2006 - 09:26:27 CST
