SQL & PL/SQL

I need to call a function within a fast formula and return multiple values back to the fast formula. If I can query many of the needed values on the same row, is there a way to return multiple values from ONE function back to the fast formula so I do not have to run a function for each value that I need. If this can be done, how would you handle this in the fast formula?

FUNCTION UPDATE_NOTICE_RESIGN(p_transaction_id IN NUMBER) RETURN VARCHAR2 IS
var1 varchar2(60)
var2 varchar2(60)
BEGIN
SELECT status, section_display_name INTO var1, var2
FROM hr_api_transactions
WHERE transaction_id = p_transaction_id;

return <var1 & var2> --Is there a way to return 2 values here?

end UPDATE_NOTICE_RESIGN;



Thanks,

M