cx-oracle-users

[cx-oracle-users] Cursor Reuse ?

[Robert <web...@gm...>]

Can I reuse a cursor ?

say I have 3 SQLs:

some_sql1
some_sql2
some_sql3

Is it rigt to do this, for each SQL ?

dev_cursor = db.cursor()
dev_cursor.execute(some_sql1)
result_set = dev_cursor.fetchall()
--do something w/ result_set

thanks

Re: [cx-oracle-users] Cursor Reuse ?

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

On 6/8/10 9:29 PM, Robert wrote:
> Can I reuse a cursor ?

Yes, that is no problem.