Loading

Migrate database oracle to postgresql: procedures.

Israil Ahmad

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...

Replies

Know the answer? Post it — somebody with the same question will find it here.