in reply to Pipe tag being entered into database

You should use placeholders when prepare()ing a DB insertion. Try this:

my $sql = qq{INSERT INTO $dbtable VALUES(GFMIS.FIXCUSTOMERPERF_SEQ.nex +tval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}; my $sth = $dbh->prepare($sql); $sth->execute($recclient, $recordid, $senddborderid, # ... (and so on for the rest of your variables) );

This is cleaner, usually more efficient and also avoids lots of quoting issues. (Note, this is probably not the cause of your problem, as holli explains above, but could save you grief in the future.)


Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -- Brian W. Kernighan