There is nothing wrong with your code. I recreated your CF code and Oracle
package, etc... in our environment (CFMX, Oracle 8.1.7) and it works just
fine. To solve this, I would look at two things:
1. The Oracle drivers you are using in your CF data sources.
2. If there is more than one version of the TEST01 package and you are
not calling the version that you think you are calling. To do this, I
would verify that you are connecting as the same Oracle user via the CF
data sources that you are connecting with when you are running the
procedure from SQL*Plus.
HTH.
Janet.
At 01:37 PM 9/16/2004 -0400, you wrote:
>Thanks to all who have offered advice thus far. I have since been able
>to get this running in SQL plus, but still get the same error in CF.
>(MX, Enterprise edition, using default Oracle driver)
>
>
>Error received: [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
>
>
>CF code used:
><cfstoredproc procedure = "schema.test01.testpckg" dataSource = "#ds#">
> <cfprocresult name="rs">
></cfstoredproc>
>
>
><cfdump var="#rs#">
>
>
>PACKAGE CODE:
>
>
>package test01 is
>
>Type ReturnSet is ref cursor;
>Procedure TestPckg(curReturnSet Out Returnset);
>Procedure TestPhn(curReturnSet Out Returnset);
>end test01;
>
>
>package body test01 is
>
> Procedure TestPckg(curReturnSet out Returnset) As
>
>
> Begin
> open curreturnset for
> select name
> from allNames
> where (ludate between to_date('20040801','YYYYMMDD') and
>to_date('20040901','YYYYMMDD'))
> or (insertdate between to_date('20040801','YYYYMMDD') and
>to_date('20040901','YYYYMMDD'));
> End;
>
>
> Procedure TestPhn(curReturnSet Out Returnset) As
>
>
> Begin
> open curreturnset for
> select phid, areacode, phonenumber
> from allPhones;
> End;
>
>end test01;
>
>Anyone spot anything wrong with the package/procedure that could cause
>this?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
