Urgent : How to insert/retrieve BLOB ??

From: Prem J Khanna <jprem_at_srmsoft.co.in>
Date: Wed, 06 Feb 2002 02:29:50 -0800
Message-ID: <F001.0040701E.20020206021818@fatcity.com>

hello everybody ,

i am on 8.1.6 / NT .
i have a table named images . it's structure is

    clip_id int not null,
    clip_image blob ,
    clip_loc varchar2(100)

i need to insert /update / retrieve a image (GIF/JPEG/TIFF) to/from this table.
i went thro' the DOCS also . but i don't find any example to do this . can anyone help me to do this ?

any sample scripts please ?

NOTE : I AM NOT USING BFILE HERE. TIA.
Jp.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Prem J Khanna
  INET: jprem_at_srmsoft.co.in

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 06 2002 - 04:29:50 CST