Hi, when I use the Z Oracle Stored Procedure object to execute a package procedure which inserts stuff into the database, the transaction does not get committed. I use a Python Script to execute the SP. I checked the source code of the ZOracle SP, and it seems that the commit gets done in the _finish() method. How can I tell if this method is called ? Thanks. Ernst
Ernst Eeldert writes:
when I use the Z Oracle Stored Procedure object to execute a package procedure which inserts stuff into the database, the transaction does not get committed. I use a Python Script to execute the SP.
I checked the source code of the ZOracle SP, and it seems that the commit gets done in the _finish() method. How can I tell if this method is called ? It's called automatically when the request finished successfully (in "ZPublisher.publish") provided that the stored procedure registers itself with Zope's transaction subsystem (something like "self._register"). Registration may have been forgotten...
Dieter
participants (2)
-
Dieter Maurer -
Ernst Eeldert