Avatar

Level 2

Hello Ananya Kuthiala

Thanks for your response.

But I can not change DB fields.

Because it is not our database.

In adobe campaign,

case 1 : By javascript code (using SQL Query)

var cnx = application.getConnection();

var table = vars.tableName;

var iSql = "MERGE INTO UOCMS02.APP_CAR_BUY_CNT APP ";

    iSql = iSql + " USING ";

    iSql = iSql + "        (SELECT IFAMILY_REPURCHASE_CNT ";

    iSql = iSql + "        , ISELF_REPURCHASE_CNT ";

    iSql = iSql + "        , SI_DI ";

    iSql = iSql + "        , SI_RESNO ";

    iSql = iSql + "        FROM " + table +" ";

    iSql = iSql + "        WHERE 1=1 ";

    iSql = iSql + "    ) SO ";

    iSql = iSql + " ON (APP.I_RESNO_DI = SO.SI_DI) ";

    iSql = iSql + " WHEN MATCHED THEN ";

    iSql = iSql + "    UPDATE SET ";

    iSql = iSql + "        APP.RE_BUY_CNT = SO.ISELF_REPURCHASE_CNT ";

    iSql = iSql + "        , APP.FAMILY_RE_BUY_CNT = SO.IFAMILY_REPURCHASE_CNT ";

    iSql = iSql + "        , REG_DT = SYSDATE ";

    iSql = iSql + " WHEN NOT MATCHED THEN ";

    iSql = iSql + "    INSERT (I_RESNO_DI, RE_BUY_CNT, FAMILY_RE_BUY_CNT, REG_DT) ";

    iSql = iSql + "    VALUES(SO.SI_DI, SO.ISELF_REPURCHASE_CNT , SO.IFAMILY_REPURCHASE_CNT , SYSDATE) ";

sqlExec(iSql);

It is ok. there is no error. But,

case 2 : By update activity (using FDA external database)

1524878_pastedImage_1.png

@I_RESNO_DI : VARCHAR2

@I_DI : NVARCHAR2

In this case, 'ORA-12704' error has occured.

I think if we can insert (or update) by query without no convert datatype, adobe campaign can insert (or update) too.

Please let me know any other tip or advice.

Thanks

Best regards,

Daeho