From oracle-l-bounce@freelists.org Thu May 12 21:48:54 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4D2msXd004588 for ; Thu, 12 May 2005 21:48:54 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4D2ms4Z004584 for ; Thu, 12 May 2005 21:48:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1BEA1192380; Thu, 12 May 2005 20:46:10 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30811-06; Thu, 12 May 2005 20:46:10 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 965DE1921D2; Thu, 12 May 2005 20:46:09 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Subject: RE: [dba_gurus] How to load & extract an Image(TIF) file into/from Oracle-BLOB? Date: Thu, 12 May 2005 19:49:27 -0600 Message-ID: <87E9F113CEF1D211A4C300902730187475964A@ddbcinc.ddbc.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [dba_gurus] How to load & extract an Image(TIF) file into/from Oracle-BLOB? Thread-Index: AcVXRRl3vCcDbldZQlSIxxHNc5yuqwAF3XKg From: "Justin Cave (DDBC)" To: "Thiagoo" , , Cc: X-archive-position: 19654 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jcave@ddbcinc.com Precedence: normal Reply-To: jcave@ddbcinc.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.2 required=5.0 tests=AWL autolearn=ham version=2.63 First, error numbers and a code sample would be helpful. Second, you need to be using 9i or later to be able to read & write binary data via UTL_FILE. You also need to use the PUT_RAW function rather than using PUT. That doesn't explain the file handle error-- are you sure that you opened the file first? Justin Cave Distributed Database Consulting, Inc. http://www.ddbcinc.com -----Original Message----- From: dba_gurus@yahoogroups.com [mailto:dba_gurus@yahoogroups.com] On Behalf Of Thiagoo Sent: Thursday, May 12, 2005 6:45 PM To: dba_gurus@yahoogroups.com; askdba@freelists.org Cc: oracle-l@freelists.org Subject: [dba_gurus] How to load & extract an Image(TIF) file into/from Oracle-BLOB? Hi All, I want to load few image files into Oracle BLOB columns and later would Iike to extract it & write in a file. How to load & extract an Image(TIF) file into/from Oracle-BLOB?, am using dbms_lob.loadfromfile() to load into Oracle. I'm retrieving thru dbms_lob.read and writing using utl_file.put, I'm not able to write in a file. How can I retrieve this..?When I try to retrieve it say File Handle error. If this image file operation is successful, I have few Word/Execl files to follow-on! Any help in this regard is highly appreciated! TIA, Best Regards, THIAGU =20 =09 --------------------------------- Yahoo! Mail Mobile Take Yahoo! Mail with you! Check email on your mobile phone. [Non-text portions of this message have been removed] =20 Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/dba_gurus/ <*> To unsubscribe from this group, send an email to: dba_gurus-unsubscribe@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/ =20 -- http://www.freelists.org/webpage/oracle-l