Skip to main content
Golden_Jet
Inspiring
June 19, 2008
Question

Does CFSTOREDPROC leave Oracle cursors open?

  • June 19, 2008
  • 1 reply
  • 399 views
I have an Oracle stored procedure I call that opens a cursor:

CREATE OR REPLACE procedure trialProc(c_test out sys_refcursor)
is
begin
open c_test for
SELECT *
FROM emp;
end;
/

My calling code in CF:
<cfstoredproc procedure = "trialProc" dataSource = "#request.dsn#" debug = "Yes">
<cfprocresult name = qOutResultSet>
</cfstoredproc>

From what I've read, when using CFPROCRESULT the cursor gets loaded into a result set. When this happens, does the cursor get closed by Oracle or CF Server? I don't want to leave a bunch of connections to the db open, as there is a finite amount and eventually they will all be used and then my app will come to a screeching halt.

Any info anyone can provide will be greatly appreciated.
This topic has been closed for replies.

1 reply

Participating Frequently
June 19, 2008
Ensure that you de-select Maintain Connections in your advanced settings for your Oracle datasource in ColdFusion Administrator.

Phil