Re: storing database handle object in a variable

[virtualsue]

What happens when you try it?

[chilukuri_perl]

Sorry to miss the point. This sored database handle object will be used in other script. i.e. it should be persistent for another script.

[Gangabass]

Why you want this? May be you better think about separating connection code in a module?

[scorpio17]

For persistent database connections, I think you should take a look at using mod_perl or FastCGI, along with something like Apache::DBI. Regular scripts will close the database connection when they exit. I don't think there's anyway to avoid that.