Problem solve Get help with specific problems with your technologies, process and projects.

Loading LONG RAW data

I need to insert a *.pdf file into a specific column. My problem is that I can't use blob because it requires having the file system on the server side, and that isn't possible. I thought about using a LONG RAW data type, but I saw an article that said that the only way to load data to a LONG RAW is via C or VB. Is this info correct? > Is there any other way of accomplished this?

Your assertion that a blob must reside on the server's file system to be loaded is only correct if you are using the BFILE datatype. If you use the BLOB datatype, then your binary file can be on any system so long as you have an application on that system to load the file into the database. This is done all the time. For instance, many Web sites let you upload files from the client's Web browser to the database.

I would stay away from LONG RAWS since they are more restrictive and will be desupported soon.

For More Information

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.