SELECT *
FROM  dba_tab_privs 
WHERE GRANTEE  IN ('XXXXXXXX')

GRANTEE  OWNER        TABLE_NAME             GRANTOR       PRIVILEGE  GRANTABLE HIERARCHY
XXXXXXXX YYYYYYYYYYY  SYS_PLSQL_71964_26_1   YYYYYYYYYYY   EXECUTE    YES       NO

SQL-Fehler: ORA-00932: inconsistent datatypes: - expected , - got
ORA-06512: in "RECORD_GROUP.F_LISTBOX", Zeile 11
00932. 00000 -  "inconsistent datatypes: expected %s got %s"

create or replace
TYPE   record_group.rec_listbox                                      
as object  (FELD_01 VARCHAR2(250),
            FELD_02 VARCHAR2(250));

create or replace
TYPE               record_group.tab_listbox                                         
as table of RECORD_GROUP.rec_listbox;

CREATE OR REPLACE
FUNCTION  record_group.f_listbox(p_SELECT_Statement IN VARCHAR2)
RETURN record_group.tab_listbox PIPELINED IS
  type r_cursor is ref cursor;
  c_LISTBOX  r_cursor;  DATA_ROW  RECORD_GROUP.REC_LISTBOX;
  
BEGIN

  OPEN c_LISTBOX FOR p_SELECT_Statement;
    LOOP
      FETCH c_LISTBOX INTO DATA_ROW;
      EXIT WHEN c_LISTBOX%NOTFOUND;
      PIPE ROW( DATA_ROW );
    END LOOP;
  CLOSE c_LISTBOX;
END F_LISTBOX;

SELECT *
FROM   TABLE(record_group.f_listbox('SELECT ''A'',
                                            ''A''
                                     FROM    dual'));

SQL> create or replace TYPE   rec_listbox
  2  as object  (FELD_01 VARCHAR2(250),
  3              FELD_02 VARCHAR2(250));
  4  /

Type created.

SQL> create or replace TYPE tab_listbox as table of rec_listbox;
  2  /

Type created.

SQL> CREATE OR REPLACE
  2  FUNCTION  f_listbox(p_SELECT_Statement IN VARCHAR2)
  3  RETURN tab_listbox PIPELINED IS
  4    type r_cursor is ref cursor;
  5    c_LISTBOX  r_cursor;
  6    DATA_ROW  REC_LISTBOX;
  7  BEGIN
  8    OPEN c_LISTBOX FOR p_SELECT_Statement;
  9      LOOP
 10        FETCH c_LISTBOX INTO DATA_ROW;
 11        EXIT WHEN c_LISTBOX%NOTFOUND;
 12        PIPE ROW( DATA_ROW );
 13      END LOOP;
 14    CLOSE c_LISTBOX;
 15  END F_LISTBOX;
 16  /

Function created.

SQL> SELECT * FROM TABLE(f_listbox('SELECT ''A'', ''A'' FROM dual'));
SELECT * FROM TABLE(f_listbox('SELECT ''A'', ''A'' FROM dual'))
                    *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got -
ORA-06512: at "MICHEL.F_LISTBOX", line 9


SQL> SELECT * FROM TABLE(f_listbox('SELECT rec_listbox(''A'', ''A'') FROM dual'));

FELD_01
---------------------------------------------------------------------------------
FELD_02
---------------------------------------------------------------------------------
A
A