True, but the stored procedure I am calling is intended to return many rows of data (tens of thousands on occasion). I need a cursor for that.

On Thu, 29 Jun 2000, David A Lipsky wrote:

...

curs = conn.cursor() conn.procedures.some_stored_procedure(curs)

Do not pass cursor - pass parameters to the procedure and it returns a result.

Oleg. (All opinions are mine and not of my employer) ----- Oleg Broytmann Foundation for Effective Policies phd@phd.russ.ru Programmers don't die, they just GOSUB without RETURN.