Hi,

I am updating a table with the amount field where ever my pros_id match.
Pros_id is a char(12) field.

**** procedure being run***
begin
c_amount account.acc_field%type;
c_pros_id account.pros_id%type;
update account
set account = c_amount
where pros_id = ltrim(rtrim(c_pros_id);
end;
****
sql> exec proc_name;
I get this error.
ORA-01861: literal does not match format string
ORA-06512: at "MNDB.UPD_CRD_RATE", line 40
ORA-06512: at line 1
If I donot use the ltrim/rtrim then I don't get the error but the records donot get updated.

Can you help me
Badrianth