You have 3 choices: 1) Get Enterprise 2) Buy the DataDirect Oracle driver and install that. 3) Write your own JDBC driver
I'll assume that 3 is out of the question. As for the other two, getting Enterprise is the better investment, considering the feature that it offers. On 3/29/07, Nathanial Thelen <[EMAIL PROTECTED]> wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274052 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
