Am 18.01.2007, 17:58 Uhr, schrieb robert rottermann <[EMAIL PROTECTED]>:

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.


Zope-DB mailing list

Reply via email to