Path: news.easynews.com!easynews!feedwest.news.agis.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: markg@mymail.co.uk (Mark) Newsgroups: comp.databases.oracle.tools Subject: Re: writing blob to file on disk in pl/sql server Date: 4 Apr 2002 01:14:29 -0800 Organization: http://groups.google.com/ Lines: 36 Message-ID: References: <3CAB2AE9.6F415FEB@exesolutions.com> NNTP-Posting-Host: 163.166.150.21 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1017911669 23897 127.0.0.1 (4 Apr 2002 09:14:29 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 4 Apr 2002 09:14:29 GMT Xref: easynews comp.databases.oracle.tools:50386 X-Received-Date: Thu, 04 Apr 2002 02:12:17 MST (news.easynews.com) Using DBMS_LOB on its own will not do all you require, you can indeed read a line from a BLOB into a variable but you need to write it to the OS. If it was a CLOB you were dealing with you use UTL_FILE to write it to the OS. However, you cant use UTL_FILE for binary info so you will have to use an External Procedure. This subject has been covered by myself and others in newsgroups, try doing a search via Google on the subject (saves me repeating myself!) I know the following link works (cut and paste whole link into browser) http://groups.google.com/groups?q=markg+blob&hl=en&selm=ab87195e.0201220107.6cdeeaeb%40posting.google.com&rnum=2 HTH, M damorgan wrote in message news:<3CAB2AE9.6F415FEB@exesolutions.com>... > Look at the DBMS_LOB package. Run the following: > > SELECT DISTINCT object_name > FROM all_arguments > WHERE package_name = 'DBMS_LOB'; > > The answer will present itself. > > Daniel Morgan > > > > PS wrote: > > > i would like to write blob into file in pl/sql. I know how to get a > > file from blob but i don't know how to write it as a file in PL/SQL. > > Is it possible?