I want to schedule a procedure using dbms_jobs. is there any way to direct
the output of that procedure to some text file. or the only way is to insert
into some temp tables and read it from there.

Regards
Oracle LazyDBA home page