sqlldr: What does the rows parameter effect?

HPUX: v10.2
Oracle7: v7.3.2.3
SQL*Loader: v7.3.2.2

I am loading data into a table, and triggers on this table are creating records (1 to 1) in a second table that keep up with the record status. Three triggers and a package are being used to get around a mutating table problem. There are several other tables which use the same status information and it is better for reporting purposes to keep all status information in one table. When SQL*Loader is used to load the data and a ROWS parameter of 1 is used, everything is processed correctly. When a larger number is used (50, 100, 500, and 1000 where tested), all of the records in the main table are created but only some of the status records get created. The percentage of status records correctly created increases as ROWS is decreased. No exception messages are returned.

Similar triggers and packages are being used on other tables without problems.

Any suggestions?

Thanks,
Brian Gastineau
bgastine_at_giveblood.org Received on Fri Jul 11 1997 - 00:00:00 CDT