RE: inserting BLOBS? Is it even possible?

You should be able to do a normal INSERT statement into a CLOB, but I've not sure about inserting into a BLOB...maybe if you convert the string to RAW
(using the UTL_RAW.CAST_TO_RAW function) the insert would work. Just a
thought...

Jeffery Stevenson
Chief Databeast Tamer
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: Dennis Taylor [mailto:ismgr_at_pctc.com] Sent: Friday, January 05, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L Subject: inserting BLOBS? Is it even possible?

I'm getting fairly freaked, here. I've got 4 Oracle manuals in various stages of "open" on my desk. I'm trying to find out how to insert or update a BLOB field in a table using just plain generic SQL. The SQL Reference implies that this is possible, but nowhere in any of the manuals does it actually show the syntax for doing so. Is it possible to do something equivalent to:

insert into SOMETABLE (BLOB_FIELD) values ('smooosh');

(This doesn't work. I've tried it.)

---
Dennis Taylor
---
Don't worry about people stealing your ideas.  If your ideas
are any good,
you'll have to ram them down people's throats.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis Taylor
  INET: ismgr_at_pctc.com

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).