getting ORA-22285: non-existent directory or file for FILEOPEN operation
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';