Including audio file in oracle 10g

[saiprashanth]

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

 

[Thargy]

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

 

[saiprashanth]

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

Thanks
-Sai

 

[lespaul]

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

 

[Thargy]

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