We have used oracle sp's to return cursors like so:
<cfstoredproc datasource="#SID#"
procedure="AKC.PKG_COMPREC.pr_get_skip_fail"
returncode="no">
<cfprocparam
dbvarname="in_cde_comp_group"
cfsqltype="cf_sql_varchar"
value="#in_cde_comp_group#"
type="in">
<cfprocparam
dbvarname="in_cde_product_type"
cfsqltype="cf_sql_varchar"
value="#in_cde_product_type#"
type="in">
<cfprocparam
dbvarname="out_return_code"
variable="out_return_code"
cfsqltype="cf_sql_float"
type="out">
<cfprocparam
dbvarname="csr_group_for_events"
variable="csr_group_for_events"
cfsqltype="CF_SQL_REFCURSOR"
type="inout">
<cfprocresult name="get_skip_fail">
</cfstoredproc>
Also you can convert pl/sql tables to a query as follows:
<cfstoredproc datasource="#SID#"
procedure="AKC.pkg_code_table_values.PR_all_breeds_by_comp_no_var"
returncode="no">
<cfprocparam
dbvarname="in_cde_competition_type"
cfsqltype="cf_sql_varchar"
value="#in_cde_comp_group#"
type="in">
<cfprocparam
dbvarname="out_t_cde_bvg_num"
variable="out_t_cde_bvg_num"
cfsqltype="cf_sql_varchar"
maxrows="200"
type="out">
<cfprocparam
dbvarname="out_t_desc_bvg"
variable="out_t_desc_bvg"
cfsqltype="cf_sql_varchar"
maxrows="200"
type="out">
</cfstoredproc>
<cfset PR_GROUPS_BREEDS=QueryNew("")>
<cfset rc=QueryAddColumn(PR_GROUPS_BREEDS, "out_t_cde_bvg_num",
out_t_cde_bvg_num)>
<cfset rc=QueryAddColumn(PR_GROUPS_BREEDS, "out_t_desc_bvg",
out_t_desc_bvg)>
I don't know if that helps but it's all I can offer.
Frederic
[EMAIL PROTECTED] wrote:
>
> I don't know if there are solaris-specific issues. In CF 4.0x it was only
> possible to do this with ugly kludges. With CF 4.5x it can be done using
> the CFSTOREDPROC tag; it's only documented in the "new features in 4.5" file
> in an area titled "Oracle Reference Cursor Support". I've used the feature
> on NT 4 without problems.
>
> -----Original Message-----
> From: Jeff Beer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 04, 2001 10:39 AM
> To: CF-Talk
> Subject: CF 4.5 ent on Solaris
>
> We have an application that will be running on CF 4.5 Enterprise on Solaris
> 2.6, against an Oracle 8i 8.15 database (also on Solaris).
>
> I'm told there will be an issue with Oracle returning recordsets using
> stored procedures in CF. Evidently the cursor type specified by CF in the
> connection is incompatible with Oracle stored procs.
>
> Does anyone have any information on this issue? I need to make some
> decisions before we create the development environment, etc.
>
> Thanks in advance,
>
> Jeff
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists