Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: my function to run in Sqlplus console

Re: my function to run in Sqlplus console

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 30 Sep 2003 14:18:42 -0700
Message-ID: <1064956722.686861@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US