detail in The ColdFusion MX Bible, including how to perform compile time
binding of refcursors to explicitly-structured record datatypes (rather than
runtime binding to an entire table structure, which is slower).
Respectfully,
Adam Phillip Churvis
Member of Team Macromedia
Advanced Intensive ColdFusion MX Training
ColdFusion MX Master Class:
September 22 - 26, 2003
http://www.ColdFusionTraining.com
Download CommerceBlocks V2.1 and LoRCAT from
http://www.ProductivityEnhancement.com
The ColdFusion MX Bible is in bookstores now!
----- Original Message -----
From: "Deanna Schneider" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 01, 2003 9:04 AM
Subject: Re: Returning Results from a Stored Proc in Oracle
> Ryan,
> Not sure if this changed with MX, but in 5.0, you had to add maxrows="-1"
to
> your out parameter, so it would look like this:
>
> <cfprocparam type="out"
> cfsqltype="cf_sql_refcursor"
> variable="p_the_results" maxrows="-1" dbvarname="p_the_results">
>
> Note that I've also used the dbvarname attribute, though I'm not sure if
> it's required.
> -d
>
>
> ----- Original Message -----
> From: "Ryan Geesaman" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Wednesday, October 01, 2003 7:14 AM
> Subject: Returning Results from a Stored Proc in Oracle
>
>
> > I am trying to use <cfstoredproc> to return results from Oracle. I have
> seen a few different suggestions on how to accomplish this, but none have
> worked.
> >
> > First Try:
> > In Oracle --
> > PACKAGE STORED_PROC_TEST
> > IS
> > TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
> > PROCEDURE get_data(p_criteria IN VARCHAR2,
> > p_the_results IN OUT CUSTOM_REF_CURSOR);
> > END;
> > In CF --
> > <cfstoredproc procedure="stored_proc_test.get_data"
> datasource="#session.dsn#">
> > <cfprocparam type="in"
> > cfsqltype="cf_sql_varchar"
> > value="test"
> > dbvarname="p_criteria">
> > <cfprocparam type="out"
> > cfsqltype="cf_sql_refcursor"
> > variable="p_the_results">
> > <cfprocresult name="dataFromStoredProc">
> > </cfstoredproc>
> > This results in "The specified SQL type is not supported by this
driver."
> >
> > Second Try:
> > In Oracle -- same as above
> > In CF -- second <cfprocparam> is dropped completely
> > This results in "wrong number or types of arguments in call to
'GET_DATA'"
> >
> > Any help would be appreciated,
> > Ryan A. Geesaman
> > Applications Developer
> > Penn State College of Medicine
> > Health Evaluation Sciences
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
