A DBI handle contains a bit (or a lot, depending on the particular DBD backend it's using) of context which may not even be valid in another process' context. Passing it (or in your case a stringified representation of it) to another process on the command line isn't going to work (depending on the DBD and what backend library it uses you might could do some wicked file descriptor voodoo in the child, but that's going to be highly DBD and database dependent if it's even possible). If it truly must be a separate process then you're going to have to reconnect in the child to the same database (in which case you could pass the DSN and credentials to it). Or rework your design so that the other code is a module or something you can run via do instead of spawning a new process.

In reply to Re: pass $dbh object to new program by Fletch
in thread pass $dbh object to new program by Sanjay

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.