pPLAYER_TABLE           varchar[],
c_Player                     refcursor

open c_Player for
      select что то
        from pPLAYER_TABLE

function myfunction(
  pTable           varchar[],
  pACCOUNT      number
) returns refcursor as $BODY$
declare
  c_Player       refcursor;
begin
  if (pTable is NULL) then
    open c_Player for
      select SUBCONT
        from ACCOUNT_BALANCE
      where ACCOUNT = pACCOUNT
  else
    open c_Player for
      select * 
      from pTable;
  end if;
 return refcursor;