Hi All,
I have a client requirement to write a single function and return two values in two plsql variables. As per my analysis, I have two options to return to calling program these two variables. Define a type or return a system ref cursor.
Also cannot use a procedure
Client's justification is why this cannot be done in a procedure is the function needs to be called in the OBIEE queries as well. Type definition is also not preferred by the client either and cannot split the function call as well.
Wonder how I can return these two values in two variables using the system refcursor. Or is there a better alternative, please advise.
Thanks