[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