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

    issue in fetching the rowcount.

    Uva

      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.

       

      Regards,

      Uva.