Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!news.tele.dk!small.news.tele.dk!194.213.69.151!news.algonet.se!algonet!lnewspeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.tools References: <3CAB2AE9.6F415FEB@exesolutions.com> Subject: Re: writing blob to file on disk in pl/sql server Date: Thu, 4 Apr 2002 11:07:06 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 37 Message-ID: <3cac25cb$0$8507$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1017914827 reading.news.pipex.net 8507 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.tools:50387 X-Received-Date: Thu, 04 Apr 2002 03:04:54 MST (news.easynews.com) Dbms_lob will not do it on its own. In addition I much prefer DESC DBMS_LOB as it tells you a lot more about thge procedures than simply argument names. -- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "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? >