Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL> CREATE OR REPLACE PROCEDURE procedure_name (
  2    column_name IN VARCHAR2,
  3    ref_cursor OUT SYS_REFCURSOR)
  4  IS
  5  BEGIN
  6    OPEN ref_cursor FOR 
  7      ' SELECT SUM (sal), ' || column_name || 
  8      ' FROM emp GROUP BY ' || column_name; 
  9  END;
 10  /

Procedure created.

SQL> SET AUTOPRINT ON;
SQL> VARIABLE ref_cursor REFCURSOR;
SQL> SPOOL emp_groups.lst
SQL> EXEC procedure_name ('DEPTNO', :ref_cursor);

PL/SQL procedure successfully completed.


  SUM(SAL)     DEPTNO
---------- ----------
      8750         10
     10875         20
      9400         30

SQL>