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
- Dozens more answers to tough Oracle questions from Brian Peasland are available.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
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.