Sprocs in Oracle vs. Other RDBMS

[plum1120]

I was recently part of a Macromedia online training session, and someone (I'll
keep names out of it for now) made a comment that CFMX and Oracle stored
procedures do not go together particularly well.

We are heavy into a CFMX/Oracle 9i sproc project architecture, and have
noticed more than our share of inexplicable (i'm saying no evidence anywhere)
failures, where our only recourse is to reboot the server, which of course
solves the issue.

Is there any experience or research or otherwise that substantiates the claim
that Oracle sprocs and CF are a sketchy combination, at least, relative to
other databases that support procedures? Anecdotal or not, I would really like
to get to the bottom of this, and change our ways if we are indeed well along a
less than ideal path.

If it matters at all, we are running ODBC vice JDBC, CFMX 6 Standard.

[paross1]

We've been using Oracle with ColdFusion since 2002, and have experienced very
few problems. We started with CF 4.5 and Oracle 8.0.6 and are now on CFMX 7 and
Oracle 9i, so we have been through the evolution to MX. Also, my Oracle
application is 100% PL/SQL stored procedures, and I use no SQL in my ColdFusion
pages. We have used ODBC, "native", and (most recently) JDBC drivers
successfully. There are a few quirks with CF various versions and drivers, but
we have had an excellent track record, and our application is very stable. ( I
had many more problems with ColdFusion and Access before I upgraded that
application to SQL Server). Your mileage may vary, of course.

Phil

[CF_Oracle]

We also have long history of creating and using Oracle8/8i/9i stored procedures
with ColdFusion 5/6/7 starting with 2001. There were no any big problems in run
and maintenance of them and most of smaller ones derived from external database
changes (data types, formats, permissions, etc). They were easily addressed and
procedures adjusted. After implementing cfqueryparams on calling CF pagesthey
ran faster and became more secure ( that clients like).