Currently using 1.0.2 > -----Original Message----- > From: Dave Carabetta [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 05, 2005 10:10 AM > To: CF-Talk > Subject: Re: CF7 and Oracle stored procedures problem > > On 10/5/05, Steve Brownlee <[EMAIL PROTECTED]> wrote: > > I believe I have found where the problem is happening with > ColdFusion 7 and > > Oracle 10 stored procedures. It appears as if there's an > endless loop going > > on in the code as per this forum message... > > > > http://www.jnetdirect.com/forum/viewtopic.php?t=156 > > > > When I take a snapshot of my JVM, I keep seeing the > following call stacks... > > > > "http-0.0.0.0-80-Processor24" daemon prio=5 tid=0x102d5938 > nid=0xc78 runnable > > [0x11c4e000..0x11c4fb68] > > at > > > coldfusion.server.j2ee.sql.JRunStatement.getUpdateCount(JRunSt > atement.java:31 > > 9) > > at coldfusion.sql.Executive.getRowSets(Executive.java:395) > > at coldfusion.sql.Executive.executeCall(Executive.java:564) > > at coldfusion.sql.Executive.executeCall(Executive.java:517) > > at coldfusion.sql.Executive.executeCall(Executive.java:477) > > at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:320) > > > > ....and... > > > > "http-0.0.0.0-80-Processor24" daemon prio=5 tid=0x102d6ca8 > nid=0xcd0 runnable > > [0x120ef000..0x120efce8] > > at > > > coldfusion.server.j2ee.sql.JRunStatement.getMoreResults(JRunSt > atement.java:23 > > 5) > > at coldfusion.sql.Executive.getRowSets(Executive.java:395) > > at coldfusion.sql.Executive.executeCall(Executive.java:564) > > at coldfusion.sql.Executive.executeCall(Executive.java:517) > > at coldfusion.sql.Executive.executeCall(Executive.java:477) > > at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:320) > > > > These calls keep happening over and over again endlessly. > I'm wondering if > > there's some way I can modify either the Oracle stored > procedures or my > > CFSTOREDPROC tag (or sub-tag) parameters to stop this from > happening. I've > > never written an Oracle stored procedure so I'm lost on > that front, but any > > advice on how/if I modify the ColdFusion end would be of > immense help. > > > > Which version of Oracle 10g are you using? Release 1 or 2? > > Regards, > Dave.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220152 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54