Re: job is done, but data does not show up in table for 1 hour

utefan001_at_gmail.com wrote:
> /* Transfer Material Costs */
> M_COMMIT_CNT := 0;
> FOR mat_rec IN material LOOP
> /* Attempt to Locate Current Record */
...
> /* Check for Commit */
> IF M_COMMIT_CNT = 100 THEN
> COMMIT;
> M_COMMIT_CNT := 0;
> END IF;
Delete the check for commit bit! You're committing inside a loop, and waiting for ORA-01555 to happen.
>
> END LOOP;
> INSERT INTO ITS_JC_TIMELOG VALUES(410,sysdate);
> COMMIT;
Make that an autonomous transaction.

-- 
Regards,
Frank van Bortel