Yes. Thanks a lot. When I set autocommit from "off" to "on", it worked as expected.

I checked perldoc DBI about the setting of autocommit when establishing a connection, but did not understand well. In practice in which situation the autocommit should be set to "off" and then call commit to make the transaction take effect.

Thanks again.