Migrate database oracle to postgresql: procedures.

Question

CREATE OR REPLACE PROCEDURE USPX_TEST (NAME IN VARCHAR2,cb_results_cursor OUT SYS_REFCURSOR) IS
BEGIN
OPEN cb_results_cursor FOR SELECT * FROM EMPLOYEES WHERE EMP_NAME = NAME;
END USPX_TEST;

Please provide me how to convert this same procedure in postgreSQL.

 

NOTE: we need to return the result in a cursor using out parameter

 

Thanks in advance...