RE: [cx-oracle-users] insert using executemanyprepared

[Chris D. <cdu...@ya...>]

Steve,

Thanks for the idea but in general my code needs to work across databases, not using db links, (I
know my simple example didn't show this but I was just using a simple test case to reproduce the
error) so I don't think INSERT /*+ APPEND */ will work. 

But if you know otherwise then pls let me know as INSERT /*+ APPEND */ is definately better for
performance.

Thanks again,

Chris
--- "Orr, Steve" <so...@ri...> wrote:

> If performance is a concern how about this?
> 
> INSERT /* APPEND */ INTO ...
> 
> 
> 
> -----Original Message-----
> From: cx-...@li...
> [mailto:cx-...@li...] On Behalf Of Chris
> Dunscombe
> Sent: Monday, March 21, 2005 12:01 PM
> To: cx-...@li...
> Subject: Re: [cx-oracle-users] insert using executemanyprepared
> 
> 
> Anthony,
> 
> It works a treat.
> 
> Thanks very much,
> 
> Chris
> 
> PS I'll give executemanyprepared a miss for now but I may come back for
> help later.
> --- Chris Dunscombe <cdu...@ya...> wrote:
> 



		
__________________________________ 
Do you Yahoo!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/