[cx-oracle-users] prepare not needed before execute many, right?

[Mark H. <mh...@pi...>]

Is there a difference between calling:

     curs.prepare("call set_x1(:a,:b)")
     curs.executemany("call set_x1(:a,:b)", mylist)

and just:

     curs.executemany("call set_x1(:a,:b)", mylist)

I know it doesn't make sense, but my test program
seems to be faster with the prepare.  I'm sure it's
other factors, but I just want to make sure I'm
not being stupid.

Many TIA!
Mark

-- 
Mark Harrison
Pixar Animation Studios