java.sql.SQLException: ORA-01401: inserted value too large for column
807591Apr 2 2008 — edited Apr 2 2008String qryinsertion="insert into emmaster values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
psinsertion=con.prepareStatement(qryinsertion);
psinsertion.setInt(1,pempcode);
psinsertion.setString(2,pname);
psinsertion.setString(3,pdesignation);
psinsertion.setInt(4,pbank_code);
psinsertion.setString(5,pbankac_code);
psinsertion.setString(6,pbankac_number);
psinsertion.setInt(7,pbankled_number);
psinsertion.setInt(8,pbasic_pay);
psinsertion.setString(9,pgiscode);
psinsertion.setInt(10,pstatus);
psinsertion.setInt(11,poffice_number);
psinsertion.setInt(12,pbill_number);
psinsertion.setString(13,pgpf_code);
psinsertion.setInt(14,pmedical_allw);
psinsertion.setString(15,pwithcpr);
psinsertion.setDate(16,java.sql.Date.valueOf(pdob));
psinsertion.setInt(17,pgis_amount);
psinsertion.setString(18,pdescp);
psinsertion.setString(19,ppt);
psinsertion.setString(20,pentity);
psinsertion.setInt(21,phrdid);
psinsertion.setInt(22,pnewofficeno);
psinsertion.setInt(23,pdesig_code);
int res=psinsertion.executeUpdate();
if(res==1)
{
JOptionPane.showMessageDialog(null,"SUCCESSFULLY ADD RECORD");
System.out.println("SUCCESS");
}
else
JOptionPane.showMessageDialog(null,"Sorry ");