I have a table which contains schedule information. Depending on the situation I may wish to select all schedule information for a driving serial or I may want to select based on start and end dates. This is quite a generic thing to want to do.
I then have a function which requires said schedule information but something inside the method will decide whether a start date is required or not.
So I want something like this:
getCursor(serial, startdate, enddate)
Inside my function:
if something or other: cursor = getCursor(serial, null, null) else cursor = getCursor(serial, start, null) Loop around cursor
Any idea about how to get this behaviour? I have looked around and seen various different methods but haven’t been able to get any of them to work. Is what I want to do event the right approach in PL/SQL? It’s not a language I often use…