Q

How can I store and retrieve movie files in Oracle?

I am developing an Oracle database where I will store movie file names and locations. On the other hand I will play these movies in Visual Basic form by a player. How can I store and retrieve these files?

Oracle can handle these Large Objects (LOBs) in the Binary Large Object (BLOB) datatype. BLOBs can hold movies,...

music clips, pictures, or any other binary data.

To learn how to code your Visual Basic application, I would recommend that you read through the Oracle® Database Application Developer's Guide - Large Objects documentation. You can find a copy of this document at the following URL:

http://download-west.oracle.com/docs/cd/B14117_01/appdev.101/b10796/toc.htm

Chapter 6 includes a section titled "Using Visual Basic (Oracle Objects for OLE (OO4O)) to Work with LOBs". Chapter 14 includes more Visual Basic specific information. I would recommend reading as much of the chapter as you can though.

This was last published in November 2004

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close