Re: writing blob to file on disk in pl/sql server
From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 4 Apr 2002 11:07:06 +0100
Message-ID: <3cac25cb$0$8507$ed9e5944_at_reading.news.pipex.net>
Date: Thu, 4 Apr 2002 11:07:06 +0100
Message-ID: <3cac25cb$0$8507$ed9e5944_at_reading.news.pipex.net>
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 [Quoted] 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" <damorgan_at_exesolutions.com> wrote in message news:3CAB2AE9.6F415FEB_at_exesolutions.com...Received on Thu Apr 04 2002 - 12:07:06 CEST
> 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?
>