×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Including audio file in oracle 10g

Including audio file in oracle 10g

Including audio file in oracle 10g

(OP)
Hi all,

I need to include a .wav file or any audio file with each entry in my table in Oracle 10g. Any thoughts as to how I can do that?

For instance,

NAME          AGE      PHNO       FILE
----------------------------------------
JOHN           22     2345555     john.wav
CARY           23     3445556     cary.wav
............

Thanks
-Sai

RE: Including audio file in oracle 10g

saip,

this would seem an ideal opportunity to use a BLOB field in your database.

Any reason why that won't do?

Regards

Tharg

Grinding away at things Oracular

RE: Including audio file in oracle 10g

(OP)
Oh..BLOB huh..any thoughts abt where I can get some examples of using it??

Thanks
-Sai

RE: Including audio file in oracle 10g

another option would be to store the file on a network path and only store the location in the database.  Adding blobs to a database can make it pretty bloated (I haven't had much exposure to Oracle, but most RDBMS I've worked with DO have that issue.)

So the field would contain:

\\servername\filelocation\filename

and then any programs that need to display the file can retrieve it and use the default program for *.wav files to open for the user.

Just another suggestion!

HTH

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

RE: Including audio file in oracle 10g

lespaul,

that's called a BFILE, and I deliberately didn'tmention it because the question stipulated internal storage.

Your post wisely raises the issue of external storage, and all the efficiencies which that can bring.  I don't believe that we have enough information to fully answer the original question at this point.

Let's hope saiprashanth posts again.

T

Grinding away at things Oracular

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close