ORA-01401: inserted value too large for column

[abby1]

ORA-01401: inserted value too large for column

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OracleClient.OracleException: ORA-01401: inserted value too large for column


Source Error:


Line 2336: Dim returnValue As Integer
Line 2337: Try
Line 2338: returnValue = command.ExecuteNonQuery
Line 2339: Finally
Line 2340: If (previousConnectionState = Global.System.Data.ConnectionState.Closed) Then

I would appreciate the help with this error i am getting. i have been working on this for the past few days now and reaching nowhere. please help!!!!! I have no knowledge of asp.net and i have to build a web base database on top of that i am not good at programming therefore i am fighting up with this error which is probably very simple to solve.

[Rabbit]

The error text is pretty self explanatory. The value that you're trying to put into the database is too big for the column in the database. You either need to make the string that you're inserting shorter or make the max length of the field longer. The choice is yours.

[abby1]

Department_ID varchar2 50
Sequencec_ID varchar2 10
Requesting Officer varchar2 50
Date_Requested Date
Date_Sent Date
Date_Returned Date
Returning_Department varchar2 50
Receiving_Officer varchar2 50
Remarks varchar2 100

Hi this is how the data is represented where i am getting the error when executing the form.

[Stewart Ross]

In post #1 returnvalue is defined as an integer. Integers can take signed values of about +/- 32,767 max. Any assignment to that integer value of a value greater than 32,767 (or less than -32768 roughly) will cause a failure.

The column definitions you posted above are varchars (text-strings) and dates. Varchars are normally used for alphanumeric combinations rather than all-numeric (whole number) values, so I'm not sure what you are doing here.

In any event, as Rabbit pointed out the error message is self-explanatory, but what you have posted above does not help us know the circumstances in which the error is occurring. We need you to post the text of the SQL statement you are trying to execute, as varchars and integer values just don't square with each other at all.

-Stewart

[abby1]

INSERT INTO "RECORDS MGMT-REQUEST"
                         (DEPARTMENT_ID, SEQUENCE_ID, REQUESTING_OFFICER, DATE_REQUESTED, DATE_SENT, DATE_RETURNED, RETURNING_DEPARTMENT, 
                         RECEIVING_OFFICER, REMARKS)
VALUES        (:DEPARTMENT_ID, :SEQUENCE_ID, :REQUESTING_OFFICER, TO_DATE(:DATE_REQUESTED, 'MM/dd/yyyy'), TO_DATE(:DATE_SENT, 'MM/dd/yyyy'), 
                         TO_DATE(:DATE_RETURNED, 'MM/dd/yyyy'), :RETURNING_DEPARTMENT, :RECEIVING_OFFICER, :REMARKS)

Hi i am trying to insert data into a table. this is the insert statement. Thanks again for the help.

[Rabbit]

I'm not sure what else to say without repeating myself.

Find which value you're trying to insert that is too long. Then either shorten the value or make the field longer.

[abby1]

@Rabbit

Hi just want to say thank you for your help. i went through all the fields and made changes as you said and saw my error. thanks again.

[Rabbit]

Not a problem abby. Good luck.

[abby1]

Thanks. i do need luck cause i have never used asp.net and its really challenging.