[Zope] DCOracle question again

2000-07-05 Thread David A Lipsky
About a week ago, I asked a question about dcoracle (Included below). I got one response suggesting that I not use a cursor. However, I need a cursor to return several (lots) of rows from the database in one stored procedure call. I can't do this by adding extra non-cursor parameters. If anyon

Re: [Zope] DCOracle Problem

2000-06-29 Thread David A Lipsky
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 n

[Zope] DCOracle Problem

2000-06-29 Thread David A Lipsky
I was wondering if you could help me with a problem I've been having with DCOrale, connecting to Oracle8i. import DCOracle conn = DCOracle.Connect(...) curs = conn.cursor() conn.procedures.some_stored_procedure(curs) curs.fetchall() curs = conn.cursor() conn.procedures.some_o