chaitu chaitu
asked on
ORA-00932: inconsistent datatypes:expected NUMBER got CHAR
when i execute this update statement I am getting this exception.docNUMBER IS VARCHAR2(50).
UPDATE docmaster VM
SET VM.docNUMBER = CASE WHEN ((SELECT instr('01108/R', 'R')
from DUAL) = 0) THEN
(310320 + 1)
ELSE
11 || '/R'
END
WHERE VM.DOC_NO = '2019154';
UPDATE docmaster VM
SET VM.docNUMBER = CASE WHEN ((SELECT instr('01108/R', 'R')
from DUAL) = 0) THEN
(310320 + 1)
ELSE
11 || '/R'
END
WHERE VM.DOC_NO = '2019154';
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER