Question
Does CFSTOREDPROC leave Oracle cursors open?
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.
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.
