469,898 Members | 1,713 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Inserting a value for a BLOB field using an SQL script

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
nj********@hotmail.com
www.nathansokalski.com

Jul 19 '05 #1
1 5184
Nathan Sokalski wrote:
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.


Please do not cross-post to every usenet group you can spell. You have
to know your request relates to only a single usenet group if you
bothered to read the charters to paid any attention to previous postings.

The whipping delivered you can find the solution at:
http://www.psoug.org
click on Morgan's Library
click on DBMS_LOB

The stored procedures can just be run as a SQL script if slightly
modified to be anonymous blocks.
--
Daniel A. Morgan
University of Washington
da******@x.washington.edu
(replace 'x' with 'u' to respond)
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by tornado | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.