flat file

From: John Duran <d3plan_at_hotmail.com>
Date: Fri, 26 Nov 1999 14:55:40 GMT
Message-ID: <81m71b$e6c$1@nnrp1.deja.com>

I need to send a fixed length file composed of header information and order information to a legacy system. (320 characters)

Where can I find an example on how to do this within ORACLE 8.0.5 running on a Sun SPARC with Solaris 2.6.

Basically every day a batch file needs to be created with billing information or basic customer information - and a series of orders each with a unique ORDER_ID and information concerning items purchased, shipping information etc.

Each detail file may have up to four different types of files each in a 320 fixed length character set. Each file type is designated by a 2 digit file type. re: type 10 is 'Buyer Info', type 30 is 'Shipping Info' type 40 is the 'Line Item Record' - one for each item ordered.

John

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 26 1999 - 08:55:40 CST