Description: an error occurred while performing DML operation “Insert” on the table XX_TABLE.
Resoultion 1: Check if there are any triggers ( AFTER TRIGGERS ) enabled on the table XX_TABLE
Resolution 2: check for any data errors like, passing null for a not null column, passing varchar data for a number column
Resolution 3: Check the stack trace, if there is any other Java.sql.SQLException, for a detailed description of the error. At times the DML operations will error out if there are any VPD ( Virtual Private Directory ) policies enabled on the table XX_TABLE, and the data we are trying to enter is not visible in the context of the user who is trying to load. Correct the data and try to execute the same DML operation.
For more information on ora-28115: policy with check option violation , go to the link : http://www.oracle-base.com/articles/8i/virtual-private-databases.php
