UPDATE TEST_CONTROL_TABLE SET PN_Date = to_date(?,'yyyymmddhh24miss'), E_From_Date = to_date(?,'yyyymmddhh24miss'), E_To_Date = to_date(?,'yyyymmddhh24miss'), E_MN = ?, E_Sts = ?, D_R_ID = ?, D_Mode = ?, D_Stts = ?, H_ID = ?, keep_M = ?, Hkeep_Sts = ?, Pr_Stt = ?, E_From_Qtes = ?, L_To_S_Qte = ?, Unque_Po_Count = ?, Unque_C_Count = ?, Unque_Endor_Count = ?, Pol_F_Record_Count = ?, Cl_File_Re_Count = ?, End_Rec_Count = ? WHERE R_ID = ?}; my $sth8 = $dbh->prepare( $sql8 ) or error(17)