Force cfstoredproc to run in background?

[13562436df]

All,

I have an Oracle(9) stored procedure that my application calls, and my current
session is set to time out in 15 minutes. On occasion the procedure does not
return in this time, (and since I've got a page that basically will log a user
out if they have no activity in that 15 minutes) and the applicaiton logs the
user out.

What I am trying to figure out is if there is someway to:

a.) Force cfstoredproc to make the call, and then return immediately, leaving
the procedure running off on it's own.
b.) Force the oracle stored proc to return immediately somehow, while still
running the procedure.
c.) Some other mysticism that makes this work.

I've google around a bit and I haven't found anyhting that describes waht I'm
looking for. I suppose I could use a cfexecute and use sqlplus to call the
procedure, but I was hoping that there was a more elegant solution.

Thanks in advance,
--james

[philh]

I'm not versed in Oracle intracacies, but I would hope it has a job engine.
What I do with MS SQL Server is issue statements within a CFQUERY tag that
create a job. The job is set to fire immediately, run the stored procedure,
and delete itself when the SP is done. The beauty of this is that the
statements that create and set the parameters for the job run immediately and
return control back to CF. In the meantime, the job runs the SP independently
of the CF process.

Check out the functionality of Oracle. I'm sure you can do something similar
in such a powerful DBMS.