problem about ora-00904-Collection of common programming errors

11 years ago
admin
1 minute

  • OMG Ponies
    sql oracle ora-00904
    I’m trying to make a chart in a database dashboard reporting software(Logi Info). I’ve got a PL SQL package that returns a ref cursor with multiple values but it seems the Logi Info does not support this and gives me an error ORA-00904: “DASHBOARD_PACKAGE”.”GETSUMMARYDATA”: invalid identifier. I think its either not supported or that my querty is wrong. This is my query:select dashboard_package.getSummaryData(1,sysdate) from dualIs that how to call a function that returns multiple values? if so,

Web site is in building