Metacat

      <sql driver="${dbDriver}"

          classpath="${jdbc}:${jdbc-add1}:${jdbc-add2}"

          url="${jdbc-connect}"

          userid="${user}"

          password="${password}"

          rdbms="oracle"

          delimiter="/">

        <transaction>

           CREATE TRIGGER xml_returnfield_before_insert

           BEFORE INSERT ON xml_returnfield FOR EACH ROW

           BEGIN

              SELECT xml_returnfield_id_seq.nextval

                 INTO :new.returnfield_id

                 FROM dual;

           END;

           /

        </transaction>

        <transaction>

           CREATE TRIGGER xml_queryresult_before_insert

           BEFORE INSERT ON xml_queryresult FOR EACH ROW

           BEGIN

              SELECT xml_queryresult_id_seq.nextval

              INTO :new.queryresult_id

              FROM dual;

           END;

           /

        </transaction>

      </sql>