Oracle 9i - storing sound files

rpeisch · #1 (**permalink**) 04-01-02, 16:23

Looking to store a discrete group of sound files in an Oracle 9i database running on Windows 2000 server. (sound files are relatively small - 25-50 KB in .AU format).The datatype is set to BLOB. Any tricks needed to insert the files into the table?

Thanks

Ajeshjoseph · #2 (**permalink**) 04-11-02, 01:47

Hi,
You can go for the appendchunk method and getchunk method , there is one more method like BLObtoFile method and BlobfromFile method , check the help for OO4O ,

bye

cr_ashok · #3 (**permalink**) 01-02-03, 04:45

Hi,
We want to store sound files in Oracle dbase. How to implement it.

bye
Ashok.

remivisser · #4 (**permalink**) 01-03-03, 07:47

Here is an example to load a binary file into a BLOB column, good luck!

http://askremi.ora-0000.com/htdocs/question/show/31

Remi