At 09:23 PM 12/6/2001 +1100, Adam Kennedy wrote: >The Situation >Oracle seems to have this lovely property where if you don't explicitly close a statement, the cursor hangs around forever... overflowing the open cursor and process limits...
Hopefully, someone will answer with a DBI solution. So, you need to send a huge file to a client, but if the client aborts the database is left in an unstable state, not freeing resources. Are you really stuck with no place to cache the output? Is there another machine on the LAN where you could redirect the request, which would then grab the data (LWP or proxy), cache it and deliver or make available? Seems like you don't want to use Oracle to waste time writing to a client. If you are running mod_perl, you can watch the connection and deal with it when it's aborted, but sending huge files to slow clients is not a good use of heavy mod_perl processes. Bill Moseley mailto:[EMAIL PROTECTED]
