Oracle Thin Client and Stored Procedures

[pdrich]

We have a stored procedures in Oracle that we are trying to call from
ColdFusion MX 7 using the Oracle Thin Client. The request hangs -- we never
get an error (that we can see in the CF logs or in the browser). There are a
lot of messages about issues with this, but I'd like to know for sure: is it
possible to call stored procedures in Oracle from CFMX7 using the Oracle Thin
Client?

[sdupre]

I remember looking at this. It's bug 57560. Oracle had this problem in the
9.2.x driver and fixed it but didn't port the fix to the 10.x driver. This
should be an everytime repro case so if you can get a stack trace (technote
18339) and send it to me, we can confirm.

My 9/2004 comments:
The stack trace shows the statement is spinning at getUpdateCount(). Oracle
had this problem with their old 9.x thin driver too. Looks like someone forgot
to port this fix to 10g drivers.

Are you using the absolute latest thin driver? I'll try this and report back.

Stephen Dupre
Macromedia QA

[pdrich]

Thank you for your response. I sent the stack trace in a private email. The
file I requested calls a simple stored proc that just runs a query but doesn?t
return a value. When I ran the page, it never completed. Eventually the
services hang and must be restarted.

Perhaps unrelated, but when I run CF using cfstart.bat, the following two
errors appeared:
no such classpath element: C:\CFUSIONMX7\runtime/../../classes
no such classpath element: C:\CFUSIONMX7\runtime\servers\lib\ojdbc14.jar

[sdupre]

Bug 61189. This was a bug in the Oracle thin driver 10.1.0.2.0. I saw the
behavior.

10.2.0.1.0 solves the problem. (from the Oracle site - that goes with the 10g
R2 release). The thin driver was hung at getUpdateCount().

"jrpp-0" prio=5 tid=0x045a5728 nid=0xb78 runnable [777f000..777fdb8]
at
coldfusion.server.j2ee.sql.JRunStatement.getUpdate Count(JRunStatement.java:231)
at coldfusion.sql.Executive.getRowSets(Executive.java :331)
at coldfusion.sql.Executive.executeCall(Executive.jav a:564)
at coldfusion.sql.Executive.executeCall(Executive.jav a:517)
at coldfusion.sql.Executive.executeCall(Executive.jav a:477)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:32 0)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(Store dProcTag.java:193)
at cfindex2ecfm1075374923.runPage(C:\cfroot\rcpDev\in dex.cfm:20) <- Line 20
is running a stored proc.

Stephen Dupre
Macromedia QA