Home Forums Reporting Services SSRS 2012 SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier RE: SharePoint SSRS ORA-00904: "LISTAGG_CLOB" invalid intentifier

  • Eirikur Eiriksson (10/23/2016)


    The error is pointing to the LISTAGG_CLOB as (as far as I can remember) there is no such function in Oracle. Chances are that it exists as something like this:

    CREATE or replace FUNCTION listagg_clob (input varchar2)

    RETURN clob

    PARALLEL_ENABLE AGGREGATE USING listagg_clob_t;

    😎

    Are you using the same credentials for both the old and the new report? Could be a permission problem.

    I didn't think there was a function like that either, but it's been quite a while since I've used Oracle. In looking at permissions like Eirikur said, be sure to consider synonym permissions as well as the function.