Ruslan Spivak wrote:
Hello, zope users!
Can anybody tell me how to call oracle stored procedure from filesystem based product?
Thanks in advance.
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Hello!!! I supose you're using DCOracle2, right? Well, what i do is using the cursor's callproc method... Basically i´ve this method below that does it... def executeProc(proc, *params): bd_connection = connect_BD() cursor = bd_connection.cursor() ret = cursor.callproc(proc, *params) cursor.close() bd_connection.close() return ret (the connect_BD calls the connect method in DCOracle2 with my connection string) Cheers Gil