Limiting results and using a dynamic column name??

[chrisrlong]

I'm not sure where you found that code, but it is wrong. What you want to do is search for 'Windowing' and you will find many posts (many from me) that will show you how to do it correctly.

Here is an example:

OPEN 
   p_fldr_cur
FOR '
   SELECT
      FLDR_ID    ,
      FLDR_NAME
   FROM
      (   -- OUTER
      SELECT
         INNER.*,
         ROWNUM
            AS QUERY_ROWNUM
      FROM
         (   -- INNER
         SELECT
            FLDR_ID    ,
            FLDR_NAME
         FROM
            INF_CAT_FLDRS
         ORDER BY 
            '||p_OrderBy||'               
         )   INNER
      WHERE
         ROWNUM   <=   :EndRow
      ) OUTER
   WHERE
      OUTER.QUERY_ROWNUM >= :StartRow   ';
USING
   p_EndRow     ,
   p_StartRow   ;

- Chris