'java.sql.SQLException: ORA-01401: inserted value to large for column' in Oracle 9i

[meenuchotijuhi]

Hi,
I've Recently joined this community coz i m very much interested in Oracle DBA track.

Actaully I' m currently working on a project where I m using Java (jdk1.4) as front end and Oracle 9i as back end.

When i connect my java gui application with Oracle db, it displays successful connection but when i try to enter some values through this application to the oracle database table then it display the following error -

'java.sql.SQLException: ORA-01401: inserted value to large for column' in Oracle 9i

I've checked the length of the variable and i entering the value which contains less value than the column size. My database column size is varchar2(20), but i m still getting this error.

If u have the solution of this problem, then plz send or reply as soon as possible on my following id -


Plz reply soon coz its urgent

Thanks
Jerry KR

[debasisdas]

The error message is self explanatory , please recheck your column size the value that you are passing

[meenuchotijuhi]

Hi

I m back here again with a new problem but this time it is based on VB .NET and MS ACCESS.

I tried a lot to start a new thread but i m not able to do so coz it seem to be that start new thread link has been disabled.

Anyways, In this project I need to Use a VB .NET Combo Box to search and retrieve records from MS access database.

I m having a window form where I had placed a combo box named comboCarMoels and its values are "SMALL","MEDIUM","LUXURY" and i had create a table name CarModels. It contains three columns i.e "SMALL","MEDIUM","LUXURY".

Now I want that when the user select "SMALL" from ComboBox then it will display all values under "SMALL" column of CarModels table.

I m in need of serious solution of this problem as soon as possible, u can send it to this email id or another email id i.e. [e-mail]

Please send the solutions as soon as possible. For thsi act of ur kindness I will remain thankful to you

Jerry KR