I am looking at a stored PROCEDURE as it takes too long to run. Besides the CURSORs, DECODE()s where NVL() should be used, and a UNION, there exists this stupidity up front:
csSpace CONSTANT CHAR(1)
cnZero CONSTANT NUMBER(1)
How many things can you spot that is just plain wrong with that?