Originally posted by shawish_sababa
by the way gcruz, you can create a counter in your programe and use dbms_output to print the status very x number of lines you fill like.
It's me again, and I don't want to be hair splitting, but the above won't work. DBMS_OUTPUT will show the output only when the whole insert operation is finished (to be more precise, when the PL/SQL block containing the insert is exited), not during the operation.