Question
CFMX 7.0.2 Pro, Oracle 10g R2, Ref Cursors, Stored Procs
I have installed all the latest hotfixes and data direct
drivers. I have the latest version of Oracle's client and JDBC
drivers installed. I have tried the thin, oci, and odbc drivers. No
matter what I do, I cannot get ref cursors to return from a stored
procedure on coldfusion professional. The error I get is:
THIN & OCI:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SEARCH_USER' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
ODBC:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC driver for Oracle]Cannot bind PL/SQL Records or Cursor References
Enterprise works every time but we are talking about almost a $5000 difference per server just for Oracle connectivity. Any ideas?
Nate
THIN & OCI:
ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SEARCH_USER' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
ODBC:
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC driver for Oracle]Cannot bind PL/SQL Records or Cursor References
Enterprise works every time but we are talking about almost a $5000 difference per server just for Oracle connectivity. Any ideas?
Nate
AdChoices