Re: Export Oracle tables to DBF files (through PL/SQL + Java)

On 5 Jul 2005 12:25:19 -0700, mascotenordico_at_yahoo.com.br wrote:

>Hi!
>
>We need to process some data (using PL/SQL) from Oracle tables and at
>the end we need to put the result (2 temporary Oracle tables) into 2
>DBF files (composed of the same fields which exist at Oracle tables).
>We would not like to have any additional step other than run the Oracle
>procedure.
>
>We already know we might use Java inside PL/SQL... that's ok, but isn't
>there any easier method? Perhaps something like UTL_FILE?
>
>By the way, does anyone have any example using Java (inside PL/SQL) to
>achieve that result (We've found JDBF, a free DBF driver at
>http://www.svcon.com/jdbf/index.html, but we aren't sure if it's a
>reliable tool)?
>
>Best Regards

Please do not multipost.

--
Sybrand Bakker, Senior Oracle DBA