Re: [Zope] oracle8 and cursors

Andy Pahne writes:

i've been using oracle8 with zope succesfully for a while. now my database programmer came up with a solution for a certain problem, which "we cannot solve with an easy select statement". he told me, that we are gonna have to use db-cursors instead.

my question is fairly simple: is there any difference in handling cursors with zsql-methods in comparison to handling 'simple' select-statements? can i use <dtml-in "..."</dtml-in> to iterate over the result sets? ZOracleDA uses a cursor internally to execute SQL statements.

If you want to create cursors dynamically, you will probably need to subclass ZOracleDA.db.Connection. Dieter