cfstoredproc for oracle driver

[AdamK]

I am currently running on CF 5 Standard and an Oracle 9i db. The problem is
that we had to use the oracle driver to run stored procs in CF 5. Is it the
same in MX 7? We are looking to upgrade but the price is extremely high
because we will need to move up to enterprise if we need to continue using the
oracle driver it is not supported in the standard version of MX 7.

[paross1]

You usually don't need to use "native" drivers to use stored procedures, as I
have used ODBC on CF 4.5 and MX 6.1 to run stored procs on Oracle 8.0, 8i, and
9i, including procs that return reference cursors. (Making sure that you don't
use the Microsoft ODBC drivers for Oracle as they suck, using the ODBC drivers
from Oracle instead ). Granted, the drivers that come with the Enterprise
version are superior to using ODBC, but it will work (also depending, of
course, on the Oracle client installed on your server).

I'm curious, what was it that required you to use the Oracle driver for CF 5?

Phil

[AdamK]

We were using the Microsoft ODBC drivers and they could not run the stored
procedures at all. The whole process would bomb before it got started. I will
try it with the ODBC drivers from Oracle and see how that goes. That was
really the only reason for us to move to enterprise. Thanks.

[AdamK]

wait you are confusing me here. The Oracle ODBC drivers are the native
drivers. Which would then mean we would have to move to enterprise. I am
looking for a way to run stored procs on the Microsoft driver so that we can
use the Standard edition.

[paross1]

No, the "native" drivers would be JDBC, but you can download ODBC drivers for
your particular version of Oracle in order to set up ODBC socket DSNs. I know
that the Microsoft ODBC for Oracle drivers do not work for stored procedures,
which is why I downloaded and installed the Oracle version (8.0.6.6.0) for my
application when it was running on Oracle 8.0.6, which was not compatible with
JDBC.

[url]http://www.oracle.com/technology/software/tech/windows/odbc/index.html[/url]

Phil