RE: Oracle Stored Procedure - another shot, now with procedure code

[Scott Mulholland]

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?


Thanks,
Scott

---
[This E-mail scanned for viruses by Declude Virus]

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

---