You completely ignored the last round of advice I gave you so I'd be dumb to offer you more advice wouldn't I? Hey ho, so be it, I'm dumb.

Your actual code shows exactly the problems my previous sample was designed to avoid.

  1. retrieve_ESLIM_codes uses the global variable $dbh
  2. retrieve_ESLIM_codes returns @sorted_parameters_A but the return result is not used
  3. look_through_file uses and updates $continue_tag, but the result is not used
  4. look_through_file populates a local @array_of_lines, but the result is not used
  5. look_through_file sets a local $entry_no_new, but the result is not used
  6. create_output is passed parameters that have no value

and so on, and so on. On top of that:

    my $dbh;
    my $sth_A = $dbh->prepare($sql_command_D) ...

[download]

is never going to give a happy result! You have a lot of work to do before your code has any chance of working.

True laziness is hard work

In reply to Re: problems passing variables between subroutine by GrandFather
in thread problems passing variables between subroutines by Freezer

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.