PLSQL 调用 返回 游标(Cursor)PROCEDURE

CREATE OR REPLACE PROCEDURE taog (p_ip IN VARCHAR2, ref1 out SYS_REFCURSOR)
IS
BEGIN
   OPEN ref1 FOR
      SELECT *
        FROM oms_ads_iplist
       WHERE (ip = p_ip or p_ip is null);
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      NULL;
   WHEN OTHERS
   THEN
      -- Consider logging the error and then re-raise
      RAISE;
END taog;

 

var cur refcursor;

exec taog(null,:cur);

print cur;