set echo on feedback on timing on serveroutput on size 1000000 spool test_exchpart exec exchpart.prepare('STATEMENT_FACT','TIM_','01-MAY-04',4,TRUE) REM ...load data into TIM_STATEMENT_FACT table here... exec exchpart.finish('STATEMENT_FACT','TIM_',4,TRUE) spool off