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

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:<4138944c$1_at_olaf.komtel.net>...
> 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 ?

SQL*Plus currently can fetch CLOBs but not BLOBs.

Can you tell us a little more on how you want to use the data? If a future version of SQL*Plus were going to support BLOBs, what commands/interface would be useful to you? Do you want the end result to be a binary file? Since SQL*Plus output is traditionally character based would a column of, say, uuencoded or base64 data be better than hex encoding?

• CJ