String or Binary Data would be truncated Error

Asked By madison escobar 0 points N/A Posted on - 02/07/2012

Hello, can someone assist me with my problem? I get an error message which goes like this:  

“Server: Msg 8152, Level 16, State 9, Procedure Trig_PUD, Line 8. String or binary data would be truncated. The statement has been terminated.”

I don’t have any single thing in mind on what this error is all about. It just appeared on the screen of my computer while I am working on it.

Thanks.

• Status: Open
• Question Views: 1350
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By ksaran 0 points N/A #102709

String or Binary Data would be truncated Error

Hi Madison

The error Msg is from SQL server, ( SQL Server Error Messages – Msg 8152 )

This normally occurs when we try to insert a value into a column of a table, where the length of the value inserted is longer than the length of the column.

From your error Msg, it seems like, it is being thrown, when an oracle procedure is getting executed.

The Procedure would have some insert statements, where a value is being inserted into a column of a table, which is not sufficient enough to hold the value, hence it gives an error message saying the value ( string or any binary data ) would be truncated to get accommodated into the column.

If you are using a dynamic insert using Select clause, then probably the sequence of columns in the select and the insert may not be the same.

Please check your code once.

Hope this helps.

Thanks

Saranya

About ksaran

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 02/08/2012
• Question Category: Misc Software