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 first published in November 2004

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close