Re: Oracle9i: How to pull LOB data via SQL*Plus ?

On Fri, 3 Sep 2004 17:56:59 +0200, "André Hartmann" <andrehartmann_at_hotmail.com> wrote:

>Hi,
>
> I wonder if the following is possible. Given an Oracle 9i client on
>Solaris and a ksh (KornShell) there is it possible to write a ksh script and
>trigger for example SQL*Plus to pull out a BLOB from a remote 9i Oracle
>Server and store the contents of the LOB in a file on the client ?
>
> I am aware that you can write .sql files and batch them under SQL*Plus and
>I also know the @ command line option of SQL*Plus. My problem is more on the
>LOB side. I know LOBs are fetched in a special way (LOB locator) so I wonder
>how to pipe the LOB data to a local file.
>
> In particular I do not want to write and compile a C program that uses OCI
>(it would be trivial using that) and also I do not want to use Perl/DBI.
>
> So, Is it possible with SQL*Plus or any other tool that comes with an
>Oracle client ? Is SQLLoader of any help ?
>
> Thanks,
>
>André
>:)
>

The dbms_lob package has functions for this.

--
Sybrand Bakker, Senior Oracle DBA