Link to home
Start Free TrialLog in
Avatar of chaitu chaitu
chaitu chaituFlag for India

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';
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chaitu chaitu

ASKER

you are lucky;am to delete this question .i got the answer
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial