SQL on connect

[prev] [thread] [next] [Date index for 2005/04/20]

On the wiki there's a doc about setting Oracle date fields by altering the 
session. As I understand it, this runs only once at *module* startup.

Now considering a mod_perl situation where you could have processes that run 
for days, and possibly DB disconnections and timeouts. DB reconnects are 
handled for us, but there's no way to re-run the do statement.

Is there a better solution where you can specify that "this SQL should be 
run after DB connection"?

Thanks

Carl