create or replace
function esp_SuggestExitPoint_v3_fun
(
v_intTier IN VARCHAR2 ,
v_exitpoint IN VARCHAR2 DEFAULT NULL

)RETURN SYS_REFCURSOR AS
cv_1 SYS_REFCURSOR;
v_SQLQry NVARCHAR2(4000);

BEGIN

v_SQLQry := 'SELECT exitpoint' || v_intTier || '_id, label FROM exitpoint' || v_intTier || '_ec WHERE 1=1 ';

IF ( v_exitpoint <> ''
OR v_exitpoint <> NULL ) THEN
BEGIN
v_SQLQry := v_SQLQry || ' ' || v_exitpoint;

END;
END IF;
-- DBMS_OUTPUT.PUT_LINE(v_SQLQry);

OPEN cv_1 FOR v_SQLQry;
Return cv_1;

END;

SQL> declare
  2    l_cmd nvarchar2(1000);
  3    l_cur sys_refcursor;
  4  begin
  5    l_cmd := 'select 1 from dual';
  6    open l_cur for l_cmd;
  7  end;
  8  /
  open l_cur for l_cmd;
                 *
ERROR at line 6:
ORA-06550: line 6, column 18:
PLS-00382: expression is of wrong type
ORA-06550: line 6, column 3:
PL/SQL: Statement ignored


SQL> declare
  2    l_cmd varchar2(1000);
  3    l_cur sys_refcursor;
  4  begin
  5    l_cmd := 'select 1 from dual';
  6    open l_cur for l_cmd;
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL>