Quinn,
I waited before responding hoping someone may offer a solution.
Unfortunately as far as I know, there aren't any JDBC drivers that
will convert a PL/SQL table to a ColdFusion array.
Your best option may be to return a ref cursor with two columns (index
& value) and write a function to convert it to a ColdFusion array.
-Adam
On 9/22/05, Quinn Ng <[EMAIL PROTECTED]> wrote:
> 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)
>
> <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>
>
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219056
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
