Re: [SOLVED]: [Zope-DB] ZSQL meyhod fr an Oracle Stored Procedure that Returns a ref_cur

2007-11-19 Thread Willi Langenberger
According to m.banaouas: > 2-add a python script for external method in Plone\Data\Extensions : > # myscript.py > def mymethod(self , somename): > conn= self.myconnection() > curext = conn.db.cursor() > curint = conn.db.cursor() > sql = "begin MY_PACKAGE.MY_PROC(:p_Cursor, :p_NAME

Re: [Zope-DB] [SOLVED]: ZSQL meyhod fr an Oracle Stored Procedure that Returns a ref_cur

2007-11-19 Thread Willi Langenberger
According to banaouas: > > If you are writing to a transactional database, you should add > > > > conn._register() > > > > to register that connection for the zope transaction > > machinery. That way the Zope Publisher calls "commit" at the end of a > > successful request (or "abort" on error).