Ricardo, first off all, stop sending HTML messages to this list. Thanks. Basically, the ZOracle Stored Procedure object returns a list containing the OUT parameters of your procedure. So when you have a Oracle Procedure like: procedure test ( p_claim_id in varchar2 ,p_cursor out cur_general ,p_error_code out number ); calling the ZOracle Stored Procedure (ZSP) from DTML will return a list containing 2 items. The first will contain a DCO2 cursor object, the second item will be the numeric errorcode. In DTML, you can use the cursor just like from python, as long as you put it into an expression. Example: <dtml-in expr="spTest()[0].fetchall()"> <li><dtml-var expr="_['sequence-item'][0]> </dtml-in> This will print a list with the values of the first column of each row. It could be that the syntax of the dtml-var tag could be less hairy, but I just started using Zope, and I know this syntax works for me. HTH, Ernst -----Original Message----- From: ricardo@cnbe.mar.org.uk [mailto:ricardo@cnbe.mar.org.uk] Sent: Friday, August 10, 2001 10:20 AM To: Zope Subject: [Zope] Oracle Stored Procedures Hi Does anyone knows how to receive a Refence Cursor variable from a stored procedue? If a stored Procedure get a result set in a query and I want to pass this resul set as output from my ZSP how do I do it? How can I do it in Zope. I saw some examples in Python by I don't know how to do it from zope. TIA Ricardo