Stacy, I think your best bet is to write a simple Java App to dump the data. You can use Prepared Statements(efficient) which works almost like SP's(creating execution structures).
I tried to use CFMX to do this.. and brought CFMX down a few times.. NOT advisable. Joe -----Original Message----- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, December 09, 2002 12:04 AM To: CF-Talk Subject: RE: Batch INSERT for Oracle? Different datasources :( Thx tho -----Original Message----- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 08, 2002 10:35 PM To: CF-Talk Subject: RE: Batch INSERT for Oracle? Is your query object from the same DataSource(Oracle)? If so.. why cant you just do... insert into TableName(field1, fields2) select field1,field2 from Tablename.. If its a different datasource.. u dont have an option.. Joe -----Original Message----- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 08, 2002 6:09 PM To: CF-Talk Subject: Batch INSERT for Oracle? Anyone know if this is possible? I've got a query object in cf I'd like to dump to Oracle in one shot rather than looping over the items and performing individual inserts. Thanks! AVIS IMPORTANT: ------------------------------- Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme. WARNING: ------------------------------- The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
