[Zope-DB]found reason: sql query works in database connector but
not in ZSQL method
charlie at egenix.com
Thu Jan 18 15:07:07 EST 2007
Am 18.01.2007, 17:58 Uhr, schrieb robert rottermann <robert at redcor.ch>:
> I think I found the reason, for my problems with stored procedures.
> it seems that on can not call a stored MySQL 5.0x procedure from zope
> that returns a data set.
If you use the mxODBC Zope DA callproc() method then you can read the last
result set returned by a procedure.
> when I call the body of the stored procedure everything works fine.
> what I now do as an interim solution, I call the "read only" procedures
> directly from python.
> procedures that alter data i call from a zope connector.
> I would be glad to here of any reason not to do this.
Yes, if you really do something outside of Zope then you are compromising
your transactional integrity.
More information about the Zope-DB