Hello,

While commiting the stored procedure, i am getting this error.


Cannot commit transaction:
This column cannot be updated because it is derived from an SQL
function or expression.
attempted update of read-only column.

What is the problem in my stored procedure?

UPDATE BATCHMASTER SET BATCHCST=:BATCHCST,
BATCHMRP=:BATCHMRP,
BATCHSELLINGRATE=:BATCHSELLINGRATE,
BATCHTPS=:BATCHTPS,
EXPIRYDATE=:EXPIRYDATE,
PURCHASECOST=:PURCHASECOST,
STOPBILLING=:STOPBILLING,
BATCHSTOCK=:ORGBATCHSTOCK+:TRANSFERQUANTITY,
EXPIRY=:EXPIRY,BATCHRATE=:BATCHRATE
WHERE BATCHNUMBER=:BATCHNUMBER AND
PRODUCTSERIALNUMBER=:PRODUCTSERIALNUMBER AND
ITEMCODE=:ITEMCODE;

This is the sql in the stored procedure.

Thanks

Sivaraman