prob.. in the increasing of sring values..

[abhit_kumar]

i have the following query which insert Voucher No. that is string like that BP0101001..

when i insert voucher no it select maximum voucher no. from database and then increase the voucher no by 1..i.e. its incresing the voucher no..automatically by taking voucher no from the database..

It increases like that...

BP0101001
BP0101002
BP0101003
BP0101004


but its coming error of:

Exception:[Oracle][ODBC][Ora]ORA-01401: inserted value too large for column

as i have already checked the insertion of all the vales size..its with in the size of database..

is there an prob.. in my following query..

plz.. make my query working for me...

Statement stmt=conn.createStatement();

stmt.execute("SELECT max(vou_no) as max_id FROM pay_header ");

results = stmt.getResultSet();

if(results.next())
{
Voucher_No=results.getString("max_id") + 1;
}
conn.setAutoCommit(false);

PreparedStatement pstmt = conn.prepareStatement(
("INSERT INTO pay_header VALUES (?)"));

pstmt.setString(1,Voucher_No);

pstmt.executeUpdate();

conn.commit();
conn.setAutoCommit(true);

[ray326]

Show us a describe on the table. It's not a good idea to "select max" on a string column so you'd be a LOT better off if your "voucher number" was really "a number."