Hi all, I've got a problem in with compiling SQL in ireport 3.5. My SQL: select * from table( GET_WEEKLY_STATISTIC_FILE(NUM_ARR(1,34),'WEEKLY') ) GET_WEEKLY_STATISTIC_FILE(NUM_ARR(1,34),'WEEKLY') is a function return table type (STATISTIC_DOWNLOAD_TBL). This SQL statement works well in ireport 3.0 and Oracle SQL Developer but when I run it in ireport 3.5, I've got error ORA-00904: "GET_WEEKLY_STATISTIC_FILE": invalid identifier I'm afraid that it don't understand nested table type, so I change SQL to select * from table(cast(GET_WEEKLY_STATISTIC_FILE(NUM_ARR(1,34),'WEEKLY') as STATISTIC_DOWNLOAD_TBL)) I still got error java.sql.SQLException: ORA-00902: invalid datatype . Am I missing something. :-/. Please help !. Thanks