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

From: <mascotenordico_at_yahoo.com.br>
Date: 5 Jul 2005 12:25:19 -0700
Message-ID: <1120591519.139471.313650@g44g2000cwa.googlegroups.com>

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 Received on Tue Jul 05 2005 - 14:25:19 CDT