Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

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?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
[robby_dobby]: if I do make it, I can at least savour their local tea! :-)
[LanX]: oh they have sleper cells everywhere
[robby_dobby]: LanX: Not really, the only problems would be from religious divides. Coptics/Moslems/ Kurds/Jews
[erix]: Zzz
[erix]: Coptics? :)
[robby_dobby]: erix: Coptic Christians in Egypt
[choroba]: Robocoptic!
[erix]: I like Coptics :)
[LanX]: Copts
[erix]: sorry - just pulling your leg

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (17)
As of 2017-04-24 16:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (442 votes). Check out past polls.