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

On Sat, 4 Sep 2004 15:16:28 +0200, "André Hartmann" <andrehartmann_at_hotmail.com> wrote:

>
>> I did exactly what you are looking for using java. If you are familiar
>> with
>> java stored procedures, you can write a stored procedure to do this
>> task
>> or you can use Java programming outside Oracle (that is what I did)
>> and write some JDBC code
>> to do the same. Nice thing about Java is that it does not have PL/SQL
>> limitation
>> of 32K. In the LOB manual, Oracle describes how to use PL/SQL, JAVA,
>> OCI, PRO*C, etc.
>
> Using java for client language is a good idea. At least it is platform
>independent. If I dont find a way to do it with SQL*PLUS directly, I will
>certainly fall back to writing a little jave/JDBY thingy.
>
>AH
>:)
>

PL/SQL is pretty platform independent too. You''ll only need to read the doco on the dbms_lob package.

--
Sybrand Bakker, Senior Oracle DBA