in reply to Nesting prepared DBI handles

Have you tried making $executed_handle a lexical ("my") variable rather than a global variable? You should get a separate variable for each call into the get_children and it should not overwrite the existing variable (but who knows how DBI internally keeps its data?). Nothing is guaranteed but it is worth a try.

CountZero

A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James

Replies are listed 'Best First'.
Re^2: Nesting prepared DBI handles
by MattLG (Beadle) on Nov 08, 2009 at 14:59 UTC

    Sorry, that was a typo. $executed_handle is scoped to get_children()

    Cheers
    MattLG

[reply]

In Section Seekers of Perl Wisdom