BLOB field in stored procedure

Hi,
i need to insert a wav file into a BLOB field in a Stored procedure by giving the path and the name of the field !

it's possible to do this ?

Best ragards.

I'd say that's not the way of doing things, there is general consensus here that files are best stored outside of the database, anyway, can't you use your programming language of choice?

Answered for you by the FAQ

Actually I tend more and more to storing the stuff in the database.
BLOB handling by the DBMS has been increasingly better in recent years (including JDBC support).
When the number of files reach several thousands (or even hundred thousands) filesystems usually cannot handle that many files very well in a single directory. So you need to start to distribute the files over several directories which doesn't make the code easier.
When you need to rollback a transaction you need to manually cleanup the file system or have some daemon doing the cleanup.
And finally backing up the whole thing is a lot easier, because only a single (DBMS) backup is needed.
But that's just my opinion...