Oracle Stored Procedure problem

[Guest]

I am upgrading to Coldfusion 8 from MX. I currently have a program that accesses Oracle 10g using a stored procedure call (cfstoredproc). It works on MX but not on 8. I can do regular queries to the Oracle database successfully. Here is the error mesage I'm receiving:

Error Executing Database Query.
[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 18: PLS-00222: no function with name 'EVENT_COUNT' exists in this scope ORA-06550: line 1, column 7: PL/SQL: Statement ignored

Any ideas?

[paross1]

Perhaps this tech note may point to one possible solution.

Updated DataDirect JDBC drivers (version 3.5)

The following problems are corrected in this release of the DataDirect drivers.

Oracle
61145 - Oracle 10g R2 not supported. cfstoredproc calls that return result sets hang the server with both the 3.3, 3.4 and 3.5 drivers until this version. The 3.5 build 13 drivers support Oracle 10g R2.

Phil