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 SERVEROUT ON
SQL>EXEC CHECK_NEXT_SEQ
PROCEDURE: Check_next_seq Print
Modified on: Mon, 9 Apr, 2018 at 3:37 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.