3 Replies Latest reply on Dec 4, 2019 1:54 PM by cormaco

    sql function compile error

    s k swain

      Dear Sir,

       

      While compiling a sql function it give error

      PLS-00201: identifier 'T_STRING_AGG' must be declared

       

      function contest is

      CREATE OR REPLACE FUNCTION PAMS49.string_agg (p_input VARCHAR2)

      RETURN VARCHAR2

      PARALLEL_ENABLE AGGREGATE USING t_string_agg;

      /

       

      this function works in in owner of this function I made import the data from the original user to new user.

       

      please help

      thanks sir