PL/SQL code to create dBase IV file

From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Tue, 11 Mar 2008 08:56:06 -0700
Message-ID: <4025610e0803110856s312a38c9ucc464856ee3d5e90@mail.gmail.com>


Probably a strange question, but does anybody have a PL/SQL package they'd be willing to share that creates a dBase IV file?

My users want me to create a dBase IV file for them, so they can directly take the file into ARC GIS, instead of taking a .csv file, loading it in Access, then exporting it it as a .dbf (Excel truncates columns).

The file structure and contents can (and will) change all the time, so the file needs to be created dynamically with varying columns based upon user selections (up to around 250 fields from 35 different tables).

I've been playing around some with heterogenous services, and it doesn't seem that will work, as I keep getting an error message that DDL operations are not allowed on a remote database.

Any ideas, suggestions, or code?

Thanks.

--

Received on Tue Mar 11 2008 - 10:56:06 CDT

Original text of this message