Re: strange cursor loop
IFNULL(..., null) does nothing except introduce needless complexity.
Complex sprocs can't be debugged in a forum like this. Only you can debug it by inserting debugging stubs and tracking what your clauses are actually doing given different inputs. I think you'll have to test every little step of the logic.
Subject
Views
Written By
Posted
1903
July 15, 2013 08:41AM
Re: strange cursor loop
883
July 15, 2013 10:01AM
841
July 20, 2013 09:09PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.