ColdFusion, although probably not the error you are showing, is if you do
not bind all your ref cursors to a valid recordset even when error
conditions result.
Besides that, I have not used an IN OUT ref cursor before from CF. If you
have no reason for keeping it that way, consider making it just an OUT. And
I use variable="" instead of dbvarname="". In MX, you are correct that you
do not put a procparam for the ref cursor in.
-----Original Message-----
From: Ryan Geesaman
[Plunkett, Matt]
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">
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
