It might be something to do with the way the refcursor is defined in the
package.  Would they be willing to change the package so the refcursor is
defined like this?

CREATE OR REPLACE
PACKAGE schemaname.testpckg
IS
TYPE curreturnset_type_ref_cursor IS REF CURSOR;

PROCEDURE testpckg(
curreturnset IN OUT curreturnset_type_ref_cursor);
END;

At 10:57 AM 9/14/2004 -0400, you wrote:
>Here is the new specification:
>
>   PROCEDURE TESTPCKG
>     Argument Name                    Type                 IN/OUT
>Default?
>     -------------------------------- -------------------- --------
>--------
>     CURRETURNSET                     REF CURSOR           IN/OUT
>
>
>The code I'm using to call it is:
>
>
><cfstoredproc procedure = "Test01.TestPckg"
>   dataSource = "#ds#">
>     <cfprocresult name="rAcct">
></cfstoredproc>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to