2 Replies Latest reply: May 19, 2014 6:45 AM by sfr.farhan RSS

    issue in fetching the rowcount.


      Hi All,


      I am struck while fetching the rowcount.


      My outfile shouls like below,


      Audit Report


      col1    col2

      ----       -----

      a          b

      c          d

      e          f


      Number of records are : 3


      So, how can i display the rowcount as 3, how to get it ?


      I tried as

      REPFOOTER PAGE LEFT 'Extract File generated successfully. Number of records:'||sql%rowcount


      but it displayed as same "sql%rowcount"  it didnot give me count.


      Please help mw with the same.