CREATE PROCEDURE ADD_NEW_RECORD (
    TABLE_NAME VARCHAR (30 ),
    TABLE_NAME_ID VARCHAR (30 ),
    TABLE_PARAM VARCHAR (30 ))
RETURNS (
    TABLE_ID INTEGER)
AS
DECLARE REC_COUNT INT;
DECLARE OLD_ID INT;
DECLARE CURR_ID INT;
BEGIN
  CURR_ID =  0 ;
  OLD_ID =  0 ;
  REC_COUNT =  0 ;
  EXECUTE STATEMENT 'SELECT Count( ' || TABLE_NAME_ID || ' ) FROM '|| TABLE_NAME INTO :REC_COUNT;

  IF (:REC_COUNT <>  0 ) THEN
  BEGIN
    FOR EXECUTE STATEMENT 'SELECT ' || TABLE_NAME_ID || ' FROM '|| TABLE_NAME||' order by ' || TABLE_NAME_ID INTO :CURR_ID
    DO
    BEGIN
      IF (OLD_ID  +1  <> CURR_ID) THEN
      BEGIN
        CURR_ID = OLD_ID  +1 ;
        BREAK;
      END
      SUSPEND;
    END
  END
  ELSE CURR_ID =  1 ;

  EXECUTE STATEMENT 'INSERT INTO ' || TABLE_NAME || '(' || TABLE_NAME_ID || ', ' || TABLE_Param || ') VALUES (' || CURR_ID || ', '|| CURR_ID || ' )';
  TABLE_ID = CURR_ID;
  SUSPEND;
END