Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

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: