I get the below error. Do i need to set a value for NO_PARSE in this procedure call.

Thanks for all the help!
Regards.

SQL>  declare
  2        l_job number;
  3     begin
  4       dbms_job.submit( l_job,
  5   'dump_csv( ''select * from    frms_bor_approps;'', ', ', ''/frmstest'', ''test007.txt'');',
  6             add_months(trunc(sysdate,'month'),1)+6,
  7            'add_months(trunc(sysdate,''month''),1)+6' );
  8         commit;
  9*    end;
 10  /
     dbms_job.submit( l_job,
     *
ERROR at line 4:
ORA-06550: line 4, column 6:
PLS-00306: wrong number or types of arguments in call to 'SUBMIT'
ORA-06550: line 4, column 6:
PL/SQL: Statement ignored
 

Hi Tom, It creates a dump file through test procedure for function dump_csv. But, it doesn't create the dump file when i schedule it through DBMS_JOB.submit. 
I did create the util_file_dir init.ora parameter. Also, the job_queue_processes parameter is set to 1. Do, i need to increase that no. I am running this job from my machine and the "d:\frmstest" directory exist in the server machine. Should that make a difference. But, it creates a dump file from my machine when i run the test proc for dump_csv function.

Sorry, for asking so many questions.
Thanks for all the help.
Regards.

below are the line no.
SQL> 15
 15*    begin
SQL> 16
 16*        l_output := utl_file.fopen( p_dir, p_filename, 'w');

SQL> declare
  2          l_rows    number;
  3      begin
  4          l_rows := dump_csv( 'select FUND, TYPE from frmsfund_xref',
  5                              ',',
  6                              'd:\frmstest',
  7                              'test.dat' );
  8         dbms_output.put_line( to_char(l_rows) ||
  9                               ' rows extracted to ascii file' );
 10     end;
 11  /

PL/SQL procedure successfully completed..  

Tom, I run the below procedure and I have also displayed the results.
Thanks Much.
Regards.

declare
          l_job number;
    begin
         dbms_job.submit( l_job,
               'declare
                   n int;
                begin
                    n := dump_csv( ''select FUND, TYPE from frmsfund_xref'',
                                   '','',
                                  ''d:/frmstest'',
                                  ''test.txt'');
               end;',
              sysdate + 2 / 1440,
             'sysdate + 2 / 1440' );
          commit;
      end;
   /

Results:

SQL> select job, what from user_jobs;

       JOB
----------
WHAT
--------------------------------------------------------------------------------
         8
declare
                   n int;
                begin
                    n := dump_csv( 'select FUND, TYPE from frmsfund_xref',
                                   ',',
                                  'd:/frmstest',
                                  'test.txt');
               end;

       JOB
----------
WHAT
-------------------------------------------------------------------------------- 

hi tom,
we are usig to generate a report and store it in database
when I test my procedure with 40 records it works just fine but as soon as I go to 50 pages it gives me error
*********
SQL> /
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "NCDBMEL.PKG_SYSTEM_REPORTS", line 86
ORA-06512: at "NCDBMEL.PKG_SYSTEM_REPORTS", line 327
ORA-06512: at "NCDBMEL.PKG_SYSTEM_REPORTS", line 369
ORA-06512: at line 9
***********

well our process is something like this

cursor for loop
 longvar := longvar || append retrieved text to long  
 longvar := longvar || carriage return
 if lines > 35 then page break
 if pages = 1000 then insert into table (long variable)
 longvar = null;
end cursor for loop

there could be 100< no. of file < 200 files per report
is there any limitation on using long in stored procedures? 

tom

i am using oracle 8.1.7.0.0 there is no dbms_metadata

furthermore i tried to use the UTL_FILE but when i have added the utl_file_dir to the init.ora nothing has changed: i am executing the command 

SQL> show  parameter utl_file;

this is the "answer"

NAME                                 TYPE    VALUE
------------------------------------ ------- -------
utl_file_dir                         string


please tell me what i have to do

thank you

theDALLA