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

From: André Hartmann <andrehartmann_at_hotmail.com>
Date: Sat, 4 Sep 2004 15:16:28 +0200
Message-ID: <4139c030$0$28460$9b4e6d93@newsread4.arcor-online.net>

> 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
:) Received on Sat Sep 04 2004 - 08:16:28 CDT