Incidentally, you don't need to use join if you're just doing a simple concatenation (which it appears you are). One of these varients suffices:

$dynam_Sql_stmt = "$dynam_Sql_stmt from $p_str_tblName where RECORDXFE
+REDTOFILE = 'I'");
# or
$dynam_Sql_stmt = $dynam_Sql_stmt . " from " . $p_str_tblName . " wher
+e RECORDXFEREDTOFILE = 'I'");
[download]

... with my preference toward the former.

But the advice from everyone else is quite good. We need more code, if only we see what the values of some of your variables are, as well as what code you've elided.

You might just have some code that's incorrect case and it can be hard to see that. use strict; will catch those kinds of errors.

s**lil*;  $*=join'',sort split q**;  s;.*;grr; &&s+(.(.)).+$2$1+; $; =
qq-$_-;s,.*,ahc,;$,.=chop for split q,,,reverse;print for($,,$;,$*,$/)
[download]