DECLARE fld_namNEW VarChar Default NEWROW.name;

  DECLARE TblCursor CURSOR FOR TblStmt;

 

  PREPARE TblStmt FROM 

   'SELECT * from AB_TCSXMLF where name = '''+fld_namNEW+'''';

 

  OPEN TblCursor;     

    IF (ROWCOUNT(TblCursor) > 0) THEN

      RAISE ERROR CODE 10000 MESSAGE ‘bla bla…….!';

    END IF; 

  CLOSE TblCursor;

  UNPREPARE TblStmt;