Skip to main content
A
Anonymous
March 20, 2008
Question

Oracle Stored Procedure problem

  • March 20, 2008
  • 1 reply
  • 501 views
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?
This topic has been closed for replies.

1 reply

P
paross1
Participating Frequently
March 20, 2008
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices