Symptoms
Stored Procedure Decimal Overflow
Diagnoses
We have a stored procedure that has been in production for quite a while.
One column on the returned table is in Decimal(18,6).But recently, the smart object is encountering error of invalid data type.
Please refer to the uploaded error message (Decimal_.JPG) and the stored procedure (SP2.JPG).
Resolution
A coldfix has been provided.