to get array from stored procedure

[qgh]

Hi All,
I am trying to find a way to access the Array of varchars being retuned by a
Oracle Stored procedure in ColdFusion MX 7.

CFPORCPARAM no longer allows Maxrows as an attribute and I am hence not able
to get the value of this parameter.

Please note that Oracle Package has the following Type - which is an Array of
varchars

TYPE char_array IS TABLE OF VARCHAR2(20) INDEX BY BINARY_INTEGER;

PROCEDURE PROC_ISTABLEOF_ARRAY (outField OUT char_array) ;

My CF code is :- (I get error with this - which says wrong type of arguments
passed)

<CFSTOREDPROC procedure="MetaData.PROC_ISTABLEOF_ARRAY"
datasource="mydatasource"> <CFPROCPARAM type="Out"
cfsqltype="CF_SQL_VARCHAR" variable="FieldName" >
</CFSTOREDPROC> <CFSET qry = QueryNew("")> <CFSET RC=QueryAddColumn(qry,
"FieldColumn", FieldName)> <CFTABLE QUERY ="qry" COLHEADERS> <CFCOL
HEADER = "FIELD NAME" TEXT = "#qry.FieldColumn#"> </CFTABLE>

[paross1]

Sorry, but there isn't any way that I know of to pass collections (what used to
be called Pl/SQL tables) from an Oracle package to CF MX 7 using a cfprocresult
or cfprocparam . There used to be a method with older versions of ColdFusion
(4.5) , but not any more.

See [url]http://www.macromedia.com/go/tn_17938[/url]

Phil