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

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é
:) Received on Fri Sep 03 2004 - 10:56:59 CDT