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]