Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Export Oracle tables to DBF files (through PL/SQL + Java)

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 05 Jul 2005 13:28:45 -0700
Message-ID: <1120595347.146547@yasure>


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

See responses in c.d.o.server. Please do not cross-post.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jul 05 2005 - 15:28:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US