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_at_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.
Date: Tue, 23 Nov 2004 06:39:56 GMT
Message-ID: <0XAod.5635$hJ6.1445_at_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.comReceived on Tue Nov 23 2004 - 07:39:56 CET