You should always use bound parameters and not concatenate strings - there are multiple reasons why, commented on perl monks many times before and in the DBI documentation too. The only thing I can think of from the code snippets you provide is that the insert into repository is rolled back or not in the same connection and not committed or in different schemas as the insert for 'testSQL' seems to match the select for 'testSQL'.