CREATE OR REPLACE PACKAGE PKG_BOT_TESTS IS
  
  FUNCTION f_test_ReturnNonEmptyCursor RETURN SYS_REFCURSOR;

END PKG_BOT_TESTS;
/
CREATE OR REPLACE PACKAGE BODY PKG_BOT_TESTS IS

  FUNCTION f_test_ReturnNonEmptyCursor RETURN SYS_REFCURSOR IS
    l_Cursor SYS_REFCURSOR;
  BEGIN
    OPEN l_Cursor FOR
      SELECT 1 AS BOT_NUM,
             'Line 1' AS BOT_VALUE
      FROM   DUAL
      UNION
      SELECT 2 AS BOT_NUM,
             'Line 2' AS BOT_VALUE
      FROM   DUAL;
    RETURN(l_Cursor);
  END f_test_ReturnNonEmptyCursor;

END PKG_BOT_TESTS;
/