proceduer returning error "ORA-01406: fetched column value was truncated"

[tabreaz]

Don't have any idea about that error, but u can try the following statement.

MERGE INTO cust_pay@tovoucher a
USING
	( SELECT msisdn,amount
	  FROM cust_pay@tovoucher
	  WHERE status=0
	)b
ON (
	a.msisdn = b.msisdn
	a.amount = b.amount
   )
WHEN MATCHED THEN
	UPDATE SET
		a.status = 9;