RE: "Too Many Declarations" Error

The person who wrote this error message was an idiot.

The error actually means:

"I could not find the function or procedure. I looked for one with the same name and the same number and datatype of parameters and did not find a match."

Check the call to the decode function, you'll almost certainly find that it has the wrong number of parameters or they have the wrong datatypes.

--
http://www.freelists.org/webpage/oracle-l