Error -6502: ORA-06502: PL/SQL: numeric or value error:

very urgent, please help.
i am getting this error and ihave tried to rmove the spaces in the data and stuff. it din work. is there ary proceudre i can use to remove all spaces or junk values like # or % and stufff..

error:
Error -6502: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

kretzschmar,
If you use the following syntax in your translate statement, there won't be any spaces to be trimmed:
select
translate('acbd+20.3#$%','1234567890.ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyzß!"§$%&/()=?+*#-_:; ',
'1234567890.') from dual

If a space is the only possible "bad" character, then Marius' solution using replace is better, or at least more readable...
I think the real questions are:
- If the field is supposed to contain numbers why isn't its datatype set to NUMBER?
- If the field is supposed to contain numbers why does it contain other characters?
- If it does contain other characters, why the heck are you going to convert them to numbers? How are you going to decide what number is the following string: "9# 9"?! Is it 99? At least that's what you're going to get using kretzschmar's query.

If your fields are supposed to contain only numbers, then convert them to a NUMBER datatype or at least perform a one-time update (using translate or replace or whatever) to get rid of the "bad" characters!
Hope that helps!

In case you're just gettign into that stuff, remember that there are V codes, and, I think some others, where the code starts with a letter. Taking the letter off is not valid, I think. Changes the meaning of the code.

It's been a few years since I worked with diagnosis codes.

I certainly never performed any math operations on them. Maybe you're rounding up, to find the general code instead of a specific one?

If you want to perform those operations, I'd take the first letter off (if it's a letter) then put it back on later.