Passing DBI database handles

[ido50]

Hi there!
Let's say I have a package called 'PacA'. On PacA I create a database handle (And connect to the database) called $PacA::dbh, using the DBI module. Now let's say PacA uses a module called 'PacA::Test', which performes operations on the database via $PacA::dbh. When trying to do so, I get an error message saying the database has gone away, or in my case 'MySQL has gone away'.
Code doesn't matter much here, could be something like (On PacA::Test of course) my $sth = $PacA::dbh->prepare("SELECT * FROM table"); $sth->execute.
What have I missed?
Thanks.

[cchampion]

Have you tried Super Search?

Perhaps Passing Database handles to other modules. may solve your problem.

[steves]

Code doesn't matter much here

Actually, it probably does matter. Can we see the code that's failing? Your basic approach should work, so it's probably a coding detail.

[ido50]

My bad guys... a disconnect statement was hiding in the code... Feel all newbie........