http://www.perlmonks.org?node_id=11106364


in reply to Re^3: Global symbol "$prepare" requires explicit package name
in thread Global symbol "$prepare" requires explicit package name

Indeed poj, it works now.

Could you tell me please, why does it need to have ? (I believe these question marks are those placeholders from the error message) in the prepare part? And why I could not run $dbh->execute("update $schema.$table set $date_col = $date_new where $where_col = 1;") or die; directly? In this particular code I donít need neither $sth handle for reuse nor the placeholders to re-execute the code (as the variables will be all the same in all the loop cycles).<\p>

Thank you very much!