MERGE INTO PROTOCOLLO a
USING (SELECT ? AS IDPROTOCOLLO,
              ? AS NPROTOCOLLO,
              ? AS ANNOPROTOCOLLO,
              ? AS NPROTOCOLLOCENTRALE,
              ? AS DATA,
              ? AS DATAREG,
              ? AS DESCOGGETTO,
              (SELECT MIN(IDTABELLE) FROM TABELLE WHERE CODICETABELLA = 37 AND NVL(RIFERIMENTO,UTCODICE) = ? ) AS IDAMBITO,
              ? AS IDPROTASL,
              ? AS IDOGGETTO,
              ? AS INOUT,
              ? AS NOTEPROTOCOLLOCENTRALE,
              ? AS DATAPROTOCOLLOCENTRALE
    FROM DUAL) b
ON (a.IDPROTASL = b.IDPROTASL)
WHEN MATCHED THEN
    UPDATE SET a.ANNOPROTOCOLLO = b.ANNOPROTOCOLLO,
              a.NPROTOCOLLOCENTRALE = b.NPROTOCOLLOCENTRALE,
              a.DATA = b.DATA,
              a.DATAREG = b.DATAREG,
              a.DESCOGGETTO = b.DESCOGGETTO,
              a.IDAMBITO = b.IDAMBITO,
              a.IDOGGETTO = b.IDOGGETTO,
              a.INOUT = b.INOUT,
              a.NOTEPROTOCOLLOCENTRALE = b.NOTEPROTOCOLLOCENTRALE,
              a.DATAPROTOCOLLOCENTRALE = b.DATAPROTOCOLLOCENTRALE
WHEN NOT MATCHED THEN
    INSERT (IDPROTOCOLLO, NPROTOCOLLO, ANNOPROTOCOLLO, NPROTOCOLLOCENTRALE, DATA,
            DATAREG, DESCOGGETTO, IDAMBITO, IDPROTASL, IDOGGETTO, INOUT, NOTEPROTOCOLLOCENTRALE, DATAPROTOCOLLOCENTRALE)
    VALUES (b.IDPROTOCOLLO, b.NPROTOCOLLO, b.ANNOPROTOCOLLO, b.NPROTOCOLLOCENTRALE, b.DATA,
            b.DATAREG, b.DESCOGGETTO, b.IDAMBITO, b.IDPROTASL, b.IDOGGETTO, b.INOUT, b.NOTEPROTOCOLLOCENTRALE, b.DATAPROTOCOLLOCENTRALE)