PL/SQL (MOSC)

MOSC Banner

getting ORA-22285: non-existent directory or file for FILEOPEN operation

edited Dec 13, 2014 12:15PM in PL/SQL (MOSC) 7 commentsAnswered

Hi Sir,

Will inserting the image in a table we are hitting the following error:

getting ORA-22285: non-existent directory or file for FILEOPEN operation

I have created the directory POLICY_ATTACH

create or replace directory POLICY_ATTACH  as ' /u01/app/oracle/Policy_Attach';

GRANT READ, WRITE ON DIRECTORY POLICY_ATTACH to public;

GRANT READ, WRITE ON DIRECTORY POLICY_ATTACH to user;

They is a image in the directory location VPD_PHYSICAL_DM.png

The following piece of code is getting error out can you please suggest on this.

DECLARE

  P_FILE_NAME VARCHAR2(200);

BEGIN

  P_FILE_NAME := 'VPD_PHYSICAL_DM.png';

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