Chris,

Oracle has a tool called UTL_FILE that will allow you to write out text file
of unlimited size to the server it resides on.  You can write a stored
procedure to create the file.  Let me know if you need more info?

Pete

                -----Original Message-----
                From:   Chris Hamer [mailto:[EMAIL PROTECTED]]
                Sent:   Tuesday, October 17, 2000 14:20
                To:     CF-Talk
                Subject:        writing files from oracle

                Is there a way to get oracle to write a csv file from a
coldfusion request.
                Does oracle have a 'bcp' type program like sql server that
writes files out
                quickly?
                I need to write a file with about 10 - 15,000 records
without over-taxing
                the cfserver.

                Chris Hamer
                Web Development
                ImageServe, Inc.
                http://www.imageserve.com
                [EMAIL PROTECTED]


        
----------------------------------------------------------------------------
--
                Archives:
http://www.mail-archive.com/[email protected]/
                To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to