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

Home -> Community -> Usenet -> c.d.o.tools -> Inserting a value for a BLOB field using an SQL script

Inserting a value for a BLOB field using an SQL script

From: Nathan Sokalski <njsokalski_at_verizon.net>
Date: Tue, 23 Nov 2004 06:39:56 GMT
Message-ID: <0XAod.5635$hJ6.1445@trndny01>


I am writing an SQL script for Oracle 9i. I have a table of which one field is of type BLOB. I would like to create an SQL script to add records to this table. What do I do to take a file and use it as the value for this field? I know how to use the function EMPTY_BLOB() as the value, but I have been unable to find a function that takes an actual image file and use it as the data. Can someone give me an example or tell me a site where I can find one? Any help would be appreciated. Thanks.

-- 
Nathan Sokalski
njsokalski_at_hotmail.com
www.nathansokalski.com
Received on Tue Nov 23 2004 - 00:39:56 CST

Original text of this message

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