i am trying to output the resultset from a stored procedure using ref cursor.
but, i am still getting this error
"Parameter Type Conflict: sqlType=2006 "
SQL {call mySchema.myPackage.spl_proc_summary( (param 1) )}
DATASOURCE spl
VENDORERRORCODE 17012
also,pardon my noviceness, how can i call the following procedure from sqlprompt in sqlplus.
exec mySchema.myPackage.spl_proc_summary(spl_resultset)??
it's not working..:(
any help would be greatly appreciated.
thanks in advance,
-sampath
My cf and pl/sql code:
create or replace package mySchema.myPackage AS
Type spl_refcursortype IS REF CURSOR;
PROCEDURE spl_proc_summary(spl_resultset OUT spl_refcursortype);
END myPackage;
create or replace package body mySchema.myPackage As
PROCEDURE spl_proc_summary(spl_resultset OUT spl_refcursortype) IS
BEGIN
OPEN spl_resultset FOR
SELECT * FROM MyTable;
END;
END;
<CFSTOREDPROC procedure=" mySchema.myPackage.spl_proc_summary" datasource="#request.datasource#">
<cfprocparam cfsqltype="CF_SQL_REFCURSOR" type="OUT">
<CFPROCRESULT NAME="rs1">
</CFSTOREDPROC>
<cfoutput>#rs1.recordcount#</cfoutput>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
