John Ziniti wrote:
Hopefully this is not OT for this list. I am having trouble understanding how to construct a BindingArray object to match and OUT param being used in one of my stored procedures. The OUT is defined in the PACKAGE as:
TYPE result_rec is RECORD ( sample_id wells.sample_id_dn%TYPE, ... etc ... );
TYPE result_table IS TABLE OF result_rec index by BINARY_INTEGER;
PROCEDURE get_qc_report ( result_tab_io IN OUT result_table, ... etc ... )
If I try to pass in (just guessing), for example:
results = cnx.BindingArray(1, 9, 'SQLT_REF')
All I get is an "ORA-00000"
results = cnx.BindingArray(1, 9, 'SQLT_RSET')
segfaults and brings down my Zope ...
I'm not sure what kind of BindingArray I should be using.
Generally the code will try to make Binding Arrays for you -- however, it doesn't handle (I dont think) multi-column table form. It does handle simple single-column result tables, in which case the type of the binding array (if you use it manually) is your column type. The code *does* handle return of cursors properly -- so if you can arrange to return a cursor into your table that will work fine. Matt Kromer Zope Corporation http://www.zope.com/