Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Reading a BFILE
Hi everyone, I'm new to using LOB's with Oracle and I'm trying to view
a BFILE that I created. I created this procedure,
CREATE OR REPLACE PROCEDURE BFILE_proc IS
File_1 BFILE := BFILENAME('FILE_DIR', 'test.pdf'); Amount INTEGER := 32767; Position INTEGER := 1; Buffer RAW(32767);
DBMS_LOB.READ(File_1, Amount, Position, Buffer);
DBMS_LOB.CLOSE(File_1);
END;
But when I call it from SQL + I get this
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
Permission denied
ORA-06512: at "SYS.DBMS_LOB", line 605 ORA-06512: at "PTLTDR.PKG_GLOBAL_2", line 98 ORA-06512: at line 1
I checked my premission and read acces was granted to me. Wondering if anyone has any ideas?
Thank you in advance,
Joaquin
Received on Mon May 17 2004 - 15:35:40 CDT
![]() |
![]() |