Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error Error ORA-06512: at "SYS.DBMS_LOB"

42506Dec 6 2005 — edited Dec 6 2005

Hi guys,
I am trying to execute a PL/SQL script from SQL Plus. I am using oracle 10g. When I try to execute this script in the Linux box, I get the following error message

DECLARE

*

ERROR at line 1:

ORA-22288: file or LOB operation FILEOPEN failed

Permission denied

ORA-06512: at "SYS.DBMS_LOB", line 523

ORA-06512: at line 59

When I try to execute the same script on a windows machine I get this error.

DECLARE

*

ERROR at line 1:

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

ORA-06512: at "SYS.DBMS_LOB", line 523

ORA-06512: at line 59

The file is created with all permissions on the OS

Do we need some permissions to execute BFiles or create a directory? Did I miss something?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2006

Added on Dec 6 2005

#general-database-discussions

1 comment

1,455 views