Accessing Oracle Bfile

[Sri Anand]

What are we doing ?
1) We ftp a PDF file to Oracle Data base which is on Unix system, using Business Object Server. Which works fine we can see the PDF in Unix file system and also as oracle user

2) We are trying to open a stream using oracle BFILE class we are getting the below exception
[Bjava.sql.SQLException: ORA-22288: file or LOB operation FILEOPEN failed Permission denied[/B]

We are not able to figure what permissions are needed to read the file.

[Sri Anand]

was my question not clear?
[ July 25, 2008: Message edited by: Raghunandan Mamidala ]

[Jeanne Boyarsky]

Raghunandan,
Firstly, please allow at least 24 hours before wondering why you aren't getting a response. Many people check the forums once a day and haven't seen your question yet.

Now on to your question. When you say you see the file in the file system, what permissions does it have? What user is the Oracle BFile connecting as? Can you show the code you are using to call BFile?

[Jeanne Boyarsky]

Since this is about an Oracle specific feature, I'll move it to our Oracle forum for you.