The attached stored procedure checks your NEXT_SEQ table's values against the maximum primary key for each table in the NEXT_SEQ table. Install it by running the SQL script as the biotics_dlink user, and run it by typing:

SQL>SET SERVEROUTPUT ON
SQL>EXEC CHECK_NEXT_SEQ