[Zope-DB] Getting OUT params from ZOracleDA stored procedure

[Matthew T. Kromer]

Tom Steele wrote:

>Howdy,
>
>I am trying to figure out how to get the OUT params from a stored procedure
>that I am calling with DCOracle2's version of ZOracleDA with dtml-call.  Is
>there any way  to get them back cleanly?  Or do I need to stick to the
>method that's in the DCOracle2's readme and use straight python?  Is there a
>doc somewhere that I missed specific to the ZOracleDA thing that goes over
>this?  Thanks.
>
>Tom
>
>  
>

Use DCOracle2's Stored Procedure objects instead of SQL methods, and the 
OUT parameters are all returned from the procedure invocation.  You'll 
need to use a python script for this, most likely -- DTML will probably 
turn the multiple arguments into a list, and then you'd need to index 
into the list.

-- 
Matt Kromer
Zope Corporation  http://www.zope.com/