0
Answer

Migrate database oracle to postgresql: procedures.

Israil Ahmad

Israil Ahmad
5y
591
1
  1. CREATE OR REPLACE PROCEDURE USPX_TEST (NAME IN VARCHAR2,cb_results_cursor OUT SYS_REFCURSOR) IS  
  2. BEGIN  
  3. OPEN cb_results_cursor FOR SELECT * FROM EMPLOYEES WHERE EMP_NAME = NAME;  
  4. 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...
Next Recommended Forum