ORACLE8, OAS3.0 and the mischevious BLOB

Greetings,

  I am currenlty using Oracle8 to store Binary Blobs (audio data), that are used by an embedded system we are developing. My group also has decided to do service provisioning through the web using OAS3.0. A neat thing we want to be able to do is to have a page that will have a bunch of links or buttons that when clicked will actually play the audio that is stored in the database. Now to actually play the audio, that is only javascript code generated in my pl/sql procedure. What I really need to know how to do is Load the blob from the DB to an OS file that the javascript can read.

  One way I was thinking of doing this is to just write my own cartridge that uses OCI to read all the blobs in, convert them to a .wav files and store them in a directory, then use ICX calls from within the cartridge to call the pl/sql cartridge and serve the page that can play all the .way files.

  Is there a better way to do this? I have never written a cartridge before, so are there any gotchas? Is this way possible?

  -Jeremy

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Nov 19 1998 - 10:53:53 CST