I do, but I am in training all week and will not be at my office to get it. If I have it at home then I will email you an example off list. It is not too hard, you write a CTL file that is called via the SQLLDR command. If you do some searching on the web you can probably find some good examples. It is a great tool, wish I could use it via CF pages at work but they do not have the executable on the web servers.
-- Aaron Rouse http://www.happyhacker.com/ On Tue, 7 Dec 2004 10:20:49 -0600, Schreck, Tom <[EMAIL PROTECTED]> wrote: > Do you have an example of how to do this? > > Thanks > > Tom Schreck > 972-361-9943 > > > > -----Original Message----- > From: Aaron Rouse [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 07, 2004 10:19 AM > To: [EMAIL PROTECTED] > Subject: Re: [CFCDev] Upload Tab Delimited file > > Do you have permissions to execute files? If so you could use > Oracle's SQLLDR tool and just trigger it from CF. Pretty certain it > will work with a tab as the delimiter. > > -- > Aaron Rouse > http://www.happyhacker.com/ > > On Tue, 7 Dec 2004 10:14:39 -0600, Schreck, Tom <[EMAIL PROTECTED]> > wrote: > > > > > > > > What's the best approach to uploading a tab delimited file using > ColdFusion? > > I'm working in an Oracle environment and I'm new to Oracle. So, for > right > > now I have to use ColdFusion. I am using <cfhttp> to turn file into a > > recordset. I'm looping over the recordset and am doing an insert > statement > > for each record. This is timing out and seems overkill. Is there a way > to > > do a bulk insert from a recordset into a table? > > > > > > > > Thanks - Tom ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
