带立即执行的引用光标 [英] Ref cursor with Execute immediate

问题描述

我想在ref_cursor中获得结果，但是我无法做到这一点.

I want to get the results in ref_cursor, but I am not able to do that.

请建议我如何使用立即执行在ref_cursor中获取结果

Please suggest me how to get the results in ref_cursor using Execute immediate

CREATE OR REPLACE PROCEDURE TEST_PROC_QT ( p_name IN VARCHAR2,
                                           p_result_set OUT sys_refcursor ) IS

  v_sql VARCHAR2(4000);

BEGIN

   v_sql := '';
   v_sql := 'SELECT * FROM USERS WHERE 1=1 ';

   IF p_name is not null THEN
     v_sql := v_sql || ' AND login_id = :v_name';
   ELSE
     v_sql := v_sql || ' AND ((1=1) or :v_name is null)';
   END IF;

   Dbms_output.put_line(v_sql);

   EXECUTE IMMEDIATE v_sql

   --OPEN p_result_set for v_sql
   --INTO p_result_set using p_name;  

END;

推荐答案

刚刚:

OPEN p_result_set for v_sql using p_name;  

这篇关于带立即执行的引用光标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！