5 Replies Latest reply on Sep 20, 2016 12:48 PM by john.christopher

    Passing parameters through Oracle Table Function

    john.christopher

      Hi All,

       

      We had a function that was changed into a Table Function,Now I need to dynamically pass the values to the table fuction.It returns Oracle Type Error

       

      select * from table(function(to_date('2010-01-11','yyyy-mm-dd'),to_date('2016-09-14','yyyy-mm-dd'),User_ID,Region));

       

       

      Can I achieve this through passing parameters for the values that is passed into the function.

       

      Your help is much appreciated.

       

       

      Regards,

      JC