Re: Sound and Image: BLOB vs. Long Raw

Actually it is pretty easy. Suppose you have a table called sounds where sound_id is a unique field ( preferably generated using a sequence) something user don't have to see and description VARCHAR2(30) and data where it is along raw. Open your forms 5.0 and create a data block based on this table. Create a layout. Then for the data item specify that it is a sound item in the property palette. then specify what you want to enable ( you should see options in the bottom of property palette). Play button, forward, fast forward bla bla... Then you would probably wanna put a data into it so you should have a button or something similiar that executes a PL/SQL statements to load a sound file into the data. like click on the button and open a file dialog and choose a sound file and then load it in. The rest is history.

Dogan

Brian Howard wrote:

> I need to put both sound recordings and images directly into the
> database. Is it best to use BLOB or Long Raw datatype? Why? And how do
> you put them in and get them out using Forms 5?
Received on Thu Jul 22 1999 - 11:17:22 CDT