I am trying to create a member function that returns the member names of expired members. My select query works outside of the member function and this member function compiles with no problems but when I call the function I get this error:
ORA-01422: exact fetch returns more than requested number of rows
I assume it is something simple but I have not been using Oracle for long so got a bit stuck with syntax. Can anyone help with this?