Line 276: l_dummy := DBMS_PIPE.RECEIVE_MESSAGE('temporary_unused_hrdm_pipe', 5);
272:
273: -- some datapump child processes are still running. Pause this process
274: -- for 5 seconds and check the status again after 5 seconds.
275: 276: l_dummy := DBMS_PIPE.RECEIVE_MESSAGE('temporary_unused_hrdm_pipe', 5); 277:
278: END LOOP;
279:
280: -- All the datapump child processes are completed. Get the status of data pump