From hdaiminger@vivonet.com Tue, 06 Feb 2001 19:03:53 -0800 From: "Helmut Daiminger" Date: Tue, 06 Feb 2001 19:03:53 -0800 Subject: Insert data into LOB column Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi! I am new to working with LOBs. I want to insert data (through SQL or PL/SQL) into a table that looks like this: column1 varchar2(100) column2 BLOB column3 number How can I insert data into that table directly? insert into table (column1, colum2, column3) values ('sample text', ?????, 12345); The BLOB can be a TXT-file or GIF-picture or bmp-picture. The file is locally stored on the hard drive. This is 8.1.6 on Win2k. Any ideas? Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Helmut Daiminger INET: hdaiminger@vivonet.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@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).