any help would be appreciated.
thanks,
-sampath
here is my procedure and cf code :
cfmx 6.1/oracle 8i
---------------
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>
----------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
