
September 11th, 2002, 06:45 PM
|
|
|
|
Join Date: Apr 2007
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Oracle 9i ASCII file
I need to create an output file from several Oracle 9i tables, which is fixed width and delimited. I am not working with this directly I am assisting my boss who is working with these files so I do not have all the information or code samples for what has been tried (sorry). The hang up is he is using Oracle Reports 9i and wants to make this export file so that we can load the data into other databases (we sell this data to folks who use all sorts of different DBMS, so there is a need to be very generic). And the only export functions that he can find are for translating the table data into Oracle Archive format. No good. I ask him about an XML output and he said he had not looked into that yet but was going to try later today. But he would much rather have the delimited flat files.
He has all the wazoo Oracle tools (Reports, Developer, blah blah) and can write PL/SQL but the development time to do that would be so great he was hoping Oracle had some export feature built in.
Little help, any ideas?!?!
OH yeah he has tried to use an ODBC connection to an MS Access DB to create the flat file with MS Access's export tool but of course the ODBC keeps corrupting.
|