Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: my function to run in Sqlplus console
quikquic_at_yahoo.com wrote:
>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
>
>
No version.
No clear description of what you're doing.
No help possible other than to refer you to http://tahiti.oracle.com
with a suggestion that you look up DBMS_LOB.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Tue Sep 30 2003 - 16:18:42 CDT