Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

Answer: How do I access Oracle B Files

by Snuggle (Friar)
on Dec 06, 2001 at 05:00 UTC ( #129823=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > How do I access Oracle B Files - Answer contributed by Snuggle

This question is pretty vauge, but here it goes...
In ORACLE, binary files are housed in a couple of different formats. LOB, BLOB, CLOB are all pretty much the same in that they hold the binary information in the database itself. BFiles are basically, as you said, pointers to files on the OS. I assume your question is that you want to populate a table with some BFiles, and not that you want to get the files actually on the database itself (BLOB).
Use of the function
BFILENAME(<directory handle>, '<filename>')
will return a handle to the bfile that you can then INSERT into the table. One thing about the <directory handle> parameter...
In your init.ora file in your Oracle Home you need to include the line
UTL_FILE_DIR = <path>

You then need to have give the directory a handle by using the following SQL:
CREATE OR REPLACE DIRECTORY <directory handle> AS '<path>'
You can check that the directory handle was made by:
SELECT * FROM sys.user_directories
It is this directory handle that you have to send to BFILENAME to tload the file pointer into the Database.

Log In?

What's my password?
Create A New User
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (3)
As of 2016-10-24 04:34 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (302 votes). Check out past polls.