Forums
This topic is locked
MX Professional Edition and Oracle 9i Stored Proc
Posted 13 Jun 2003 17:16:24
1
has voted
13 Jun 2003 17:16:24 CHRISTINE BETTERTON posted:
I am able to call & execute a stored procedure, passing values into the procedure & returning a single value via CFPROCPARAM. Now I need to return a record set. I believe that I need to use a Ref Cursor, but whenever I do this I get an error stating that the called procedure name (ie. add_rec) has not been declared. Is there a way to use a reference cursor with any driver that's included with the Professional version? If so, what driver, how do I access/download the driver & how do I configure it? I've tried the Oracle JDBC Thin Driver and an ODBC socket. We can't go & fork out another couple grand for just a driver.