I have the snippet now from them. This is how it's currently defined
(which looks like it's in line with what you posted aside from In Out):
Type ReturnSet is ref cursor;
Procedure testpckg(curReturnSet Out Returnset);
They had switched it before to be In Out for me and I still had the same
error. The one thing I did notice is they do not have it defined with a
schema name, they just have:
package Test01 is
Type ReturnSet is ref cursor;
Procedure testpckg(curReturnSet Out Returnset);
Could that possible cause a permissions issue as Adam had alluded too?
Thanks,
Scott
-----Original Message-----
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 14, 2004 11:11 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures
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]
