ORA-01861 : WHILE USING LTRIM(RTRIM(VAR_NAME));

[badrinathn]

Hi,

I have changed the c_pros_id to varchar2(12) and as I don't want to restrict the size of the column, I am not using substr(c_pros_id,1,5).

Still the problem persists

Badrinath