Database Administration (MOSC)

MOSC Banner

DBMS_LOB.FILEEXISTS : when we check file on CIFS.

edited Jun 19, 2012 10:27PM in Database Administration (MOSC) 3 commentsAnswered
Hi all,
when i try to execute from sqldeveloper a test case :
onnecting to the database APINTDBD - APEX_APDEV.
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.

The same procedure execute from user oracle on the system directly attach at the DB .

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center