What syntax do I use in cfmx to retrieve oracle ref cursors as cf
recordsets?
The following is what I used in CF5 but it doesn't work in MX:
<cfstoredproc datasource="#SID#"
procedure="AKC.pkg_store_util.pr_sub_category_list"
returncode="no">
<cfprocparam
dbvarname="in_cde_category"
cfsqltype="cf_sql_varchar"
value="#request.category_cde#"
type="in">
<cfprocparam
dbvarname="out_sub_category_list"
variable="out_sub_category_list"
cfsqltype="cf_sql_refcursor"
maxrows=-1
type="out">
<cfprocparam
dbvarname="out_desc_category"
variable="desc_category"
cfsqltype="cf_sql_varchar"
type="out">
<cfprocresult name="sub_category_list" resultset="1">
</cfstoredproc>
Thanks,
Frederic
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
