[Zope] oracle8 and cursors

Dieter Maurer dieter@handshake.de
Wed, 5 Jul 2000 22:22:27 +0200 (CEST)


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