Xref: alice comp.databases.oracle.server:75652 Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail From: John Duran Newsgroups: comp.databases.oracle.server Subject: flat file Date: Fri, 26 Nov 1999 14:55:40 GMT Organization: Deja.com - Before you buy. Lines: 21 Message-ID: <81m71b$e6c$1@nnrp1.deja.com> X-Article-Creation-Date: Fri Nov 26 14:55:40 1999 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt) X-Http-Proxy: 1.1 x40.deja.com:80 (Squid/1.1.22) for client 63.74.106.78 X-MyDeja-Info: XMYDJUIDd3plan 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.