CREATE OR REPLACE
FUNCTION test_func
    (
      po_sql_code OUT INTEGER,
      po_sql_message OUT NVARCHAR2 
    )
    RETURN INTEGER IS
    v_sql NVARCHAR2(200);
    v_count	INTEGER;
    cur_count pkg_util.cursortype;
  BEGIN
    v_sql := 'SELECT COUNT(*) from some_table' ;
    OPEN cur_count FOR TRANSLATE(v_sql USING CHAR_CS);
    FETCH cur_count INTO v_count;
    CLOSE cur_count;
    IF v_count > 0 THEN 
      RETURN 0;
    ELSE
      RETURN -1;
    END IF;
  EXCEPTION
  WHEN OTHERS THEN
    po_sql_code    := SQLCODE;
    po_sql_message := SQLERRM;
    RETURN -1;
  END;

CREATE OR REPLACE
PACKAGE PKG_UTIL
AS
TYPE cursortype
IS
  REF  CURSOR;
  FUNCTION getUtcDateMSeconds RETURN NUMBER;
  FUNCTION getMiliseconds  RETURN NUMBER;
  PROCEDURE sleep(pi_interval NUMBER );
END PKG_UTIL;

SQL> CREATE OR REPLACE
  2  FUNCTION test_func
  3      (
  4        po_sql_code OUT INTEGER,
  5        po_sql_message OUT NVARCHAR2 
  6      )
  7      RETURN INTEGER IS
  8      v_sql NVARCHAR2(200);
  9      v_count INTEGER;
 10      cur_count pkg_util.cursortype;
 11    BEGIN
 12      v_sql := 'SELECT COUNT(*) from some_table' ;
 13      OPEN cur_count FOR TRANSLATE(v_sql USING CHAR_CS);
 14      FETCH cur_count INTO v_count;
 15      CLOSE cur_count;
 16      IF v_count > 0 THEN 
 17        RETURN 0;
 18      ELSE
 19        RETURN -1;
 20      END IF;
 21    END;
 22  /

Function created.

SQL> exec :ret := test_func(:code,:msg) 
BEGIN :ret := test_func(:code,:msg); END;

*
ERROR at line 1:
ORA-00900: invalid SQL statement
ORA-06512: at "MICHEL.TEST_FUNC", line 12
ORA-06512: at line 1

SQL> CREATE OR REPLACE
  2  FUNCTION test_func
  3      (
  4        po_sql_code OUT INTEGER,
  5        po_sql_message OUT NVARCHAR2 
  6      )
  7      RETURN INTEGER IS
  8      v_sql NVARCHAR2(200);
  9      v_sql2 VARCHAR2(200);
 10      v_count INTEGER;
 11      cur_count pkg_util.cursortype;
 12    BEGIN
 13      v_sql := N'SELECT COUNT(*) from some_table' ;
 14      v_sql2 := TRANSLATE(v_sql USING CHAR_CS);
 15      OPEN cur_count FOR v_sql2;
 16      FETCH cur_count INTO v_count;
 17      CLOSE cur_count;
 18      IF v_count > 0 THEN 
 19        RETURN 0;
 20      ELSE
 21        RETURN -1;
 22      END IF;
 23    END;
 24  /

Function created.

SQL> exec :ret := test_func(:code,:msg) 
BEGIN :ret := test_func(:code,:msg); END;

*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at "MICHEL.TEST_FUNC", line 14
ORA-06512: at line 1