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:218997
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
