That is the limitation of DECODE, even if you use nested DECODE, the maximum number of argument is 255 (that includes both condition and expression). Try using CASE statement in your SQL and see if that solves your problem. CASE is available in SQL starting with 8i and in PL/SQL starting with Oracle 9i.
I personally never used that many parameter in a DECODE statement, so I ran a simulation to confirm my answer. Please try using CASE and see if that resolves your problem.
Dig Deeper on Using Oracle PL-SQL
Related Q&A from Azim Fahmi
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.