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

---

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

---