parametrizing ORDER BY in PL/SQL (oracle 8.0.5)

Hi,

I'm trying to ORDER BY my query using a in-parameter. As we all know it is possible to ORDER BY using a column index. Can this index be passed as a parameter.

Example function that compiles but still doesn't order by the parameter - instead it orders by column 1:

   FUNCTION getfoobar (

      inorderby IN NUMBER
   )

      RETURN foobar_curtype
   IS

      rc foobar_curtype;
   BEGIN

      OPEN rc FOR
         SELECT f.name, f.address, f.phone, f.department
           FROM footable f
          ORDER BY inorderby ASC;
      RETURN rc;