From: Thomas Chiverton
Sent: Friday, February 13, 2004 10:24 AM
To: CF-Talk
Subject: Re: the oracle, the stored procedure and the cfstoredproc
On Friday 13 February 2004 15:19 pm, Plunkett, Matt wrote:
> > IS
> > possible though, we use Oracle stored procs extensively from CF MX and
5.0.
> That return ref cursor-type result sets ?
> If so, could you just c+p one so I can check neither of us is going
mad...
The TYPE declaration is in the package spec. The cfprocparam that is
commented out would be not commented in 5.0. As far as I know a ref cursor
is the only kind of cursor you can get back in CF.
TYPE ref_something IS REF CURSOR;
PROCEDURE get_something (
p_date_from IN VARCHAR2,
p_date_to IN VARCHAR2,
p_date_mask IN VARCHAR2 DEFAULT 'MM/DD/YYYY',
p_display_all IN NUMBER,
p_display_reports IN NUMBER,
p_format IN NUMBER,
p_order_by IN VARCHAR2, --order by clause
p_ref OUT ref_something,
p_status OUT NUMBER
)
<cfstoredproc procedure="MYPACKAGE.get_something"
datasource="#dataSource#"
username="#username#"
password="#password#"
returncode="No">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="p_date_from"
value="#DateFrom#">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="p_date_to"
value="#DateTo#">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="p_date_mask"
value="MM/DD/YYYY">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="p_display_all"
value="1">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER"
variable="p_display_reports" value="0">
<cfprocparam type="In" cfsqltype="CF_SQL_INTEGER" variable="p_format"
value="0">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="p_order_by"
value="">
<!--- <cfprocparam type="Out" cfsqltype="CF_SQL_REFCURSOR" maxrows="-1"
variable="p_ref"> --->
<cfprocparam type="Out" cfsqltype="CF_SQL_INTEGER" variable="p_status">
<cfprocresult name="qrySomething">
</cfstoredproc>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
