DBMS_LOB.FILEEXISTS : when we check file on CIFS.
Hi all,
when i try to execute from sqldeveloper a test case :
It 's OK.
if the directorie is on local filesystem it's also ok.
when i try to execute from sqldeveloper a test case :
onnecting to the database APINTDBD - APEX_APDEV.The same procedure execute from user oracle on the system directly attach at the DB .
ORA-22288: échec de l'opération FILEEXISTs sur le fichier ou le LOB
Permission denied
ORA-06512: à "SYS.DBMS_LOB", ligne 786
ORA-06512: à "APEX_APDEV.TEST", ligne 5
ORA-06512: à ligne 6
Process exited.
Disconnecting from the database APINTDBD - APEX_APDEV.
It 's OK.
SQL> connect apex_apdev/xxxxxxxx
Connected.
SQL> SET SERVEROUTPUT ON
SQL> exec TEST('test');
Yes
PL/SQL procedure successfully completed.
SQL> exit
if the directorie is on local filesystem it's also ok.
0