logging in as the schema owner?
-Adam
----- Original Message -----
From: Scott Mulholland <[EMAIL PROTECTED]>
Date: Tue, 14 Sep 2004 10:57:27 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk <[EMAIL PROTECTED]>
Thanks Adam. The change has been made but I'm still getting the same
error.
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>
<cfdump var="#rAcct#">
We've also tried calling it with:
<cfquery name="testSP" datasource="#ds#">
{Call Test01.TestPckg}
</cfquery>
The error we are seeing is:
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'TESTPCKG'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored
Any further input is greatly appreciated as I seem to have exhausted the
macromedia knowledge base articles.
Thanks,
Scott
-----Original Message-----
From: Adrocknaphobia [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 10:18 AM
To: CF-Talk
Subject: Re: Oracle Stored Procedures
That cursor return needs to be set to IN OUT, not just OUT.
-Adam
----- Original Message -----
From: Scott Mulholland <[EMAIL PROTECTED]>
Date: Mon, 13 Sep 2004 11:12:19 -0400
Subject: RE: Oracle Stored Procedures
To: CF-Talk <[EMAIL PROTECTED]>
Janet,
Thanks for the tip!
PROCEDURE TESTPCKG
Argument Name Type IN/OUT
Default?
-------------------------------- -------------------- --------
--------
CURRETURNSET REF CURSOR OUT
-----Original Message-----
From: Janet Schmitt [mailto:[EMAIL PROTECTED]
Sent: Monday, September 13, 2004 9:23 AM
To: CF-Talk
Subject: RE: Oracle Stored Procedures
In SQL*Plus, you can see the package specification and hence the
procedure
definition by entering the DESC command at the SQL*Plus prompt. For
example; DESC schema_name.package_name;
The DESC will not show you the code inside the package but it will show
you
what each procedure expects for parameters.
HTH.
Janet.
At 05:01 PM 9/10/2004 -0400, you wrote:
>I do not have the package unfortunately.
>
>-----Original Message-----
>From: Janet Schmitt [mailto:[EMAIL PROTECTED]
>Sent: Friday, September 10, 2004 12:49 PM
>To: CF-Talk
>Subject: Re: Oracle Stored Procedures
>
>What does the package specification for TESTPCKG look like?
_____________________________________
_____________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
