my function to run in Sqlplus console

I am running oracle. Besides all those build-in "select, insert, delete...", can I define my own function which can be run inside SQL-plus console?

Suppose I save an image as a blob in the database, my table is

ImageID blob

100     **
101     **

and I would like to have something like "Showimage blob from imagetable where imageid = 100", where "Showimage" will be a function written in C and packaged as a dll.

How can I do it?

Thanks,

qk Received on Tue Sep 30 2003 - 12:25:55 CDT