compiles it (the schema owner). Janet what are you thoughts on the
variable type? I haven't been able to return a ref cursour when its
specified as just OUT.
I still think the account they are giving you isnt kosher. Atleast if
you test it as the schema owner, it can rule that out.
-Adam
----- Original Message -----
From: Scott Mulholland <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 13:49:52 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk <[EMAIL PROTECTED]>
Janet,
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]
