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]
