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]
