CREATE OR REPLACE PROCEDURE OWA_EMP AS

      output utl_file.file_type;
begin
    output := utl_file.fopen( 'ORSC_REPORTS', 'emp1.slk', 'w',32000 );

    owa_sylk.show(
        p_file => output,
        p_query => 'select empno id, ename employee,
                           sal Salary, comm commission ' ||
                   'from emp ' ||
                   'where job = :JOB ' ||
                   'and sal > :SAL',
        p_parm_names => 
               owa_sylk.owaSylkArray( 'JOB', 'SAL'),
        p_parm_values =>
                 owa_sylk.owaSylkArray( 'MANAGER', '2000' ),
       p_sum_column =>
                 owa_sylk.owaSylkArray( 'N', 'N', 'Y', 'Y'),
        p_show_grid => 'NO' );

    utl_file.fclose( output );
end;


exec OWA_EMP


Errors:

BEGIN OWA_EMP; END;
Error at line 1
ORA-06533: Subscript beyond count
ORA-06512: at "ORSC_RMS.OWA_SYLK", line 30
ORA-06512: at "ORSC_RMS.OWA_SYLK", line 267
ORA-06512: at "ORSC_RMS.OWA_EMP", line 7
ORA-06512: at line 1

Script Terminated on line 26.