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