Need to simplify an if else statement within a cursor

[Dan Grindstaff]

Hi All,

I have a multi if-else statement inside a REF CURSOR that is part of a packaged function. There are four possible conditions and two possible select statements within the four:

BEGIN IF param1 = 1 AND param2= 3 THEN     c_stmt_str :=' SELECT statement 1 '; ELSIF param1 = 0 AND param2 = 3 THEN c_stmt_str :=' SELECT statement 2 ';    ELSIF param1 = 1 AND param2 = 4 THEN c_stmt_str :=' SELECT statement 1 ';    ELSIF param1 = 0 AND param2 = 4 THEN c_stmt_str :=' SELECT statement 2 '; END IF;

I have been asked to convert this to use an EXPLICIT CURSOR.  I would like to simplify this as such.  Any help is greatly appreciated.

Thank you