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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
