0 Replies Latest reply on Jun 12, 2019 1:06 PM by dinothedinamite

    Inserting XML data into Oracle XE via IBM IIB application, data gets transformed into Korean characters

    dinothedinamite

      Hi, I've been trying to insert XML data into my Oracle XE database with application that is made in IBM Integration Toolkit. Made a simple message flow with MQ Input and Output and Compute node in which is ESQL node.

      After sending my simple XML file into message flow, data gets inserted into database but it gets transformed into Korean characters.

      I've tried doing the same thing with IBM DB2 database and data was inserted as it should be.

      Looked around the Internet for the solution but couldnt find anything.

      Any ideas/feedback would be appreciated.

       

      ESQL code:

      CREATE COMPUTE MODULE SimpleDB_mf_Compute

      CREATE FUNCTION Main() RETURNS BOOLEAN
      BEGIN
        CALL CopyMessageHeaders();
        -- CALL CopyEntireMessage();
        INSERT INTO Database.dkralj.emp VALUES(InputRoot.XMLNSC.emp.name);
        SET OutputRoot.XMLNSC.DBINSERT.STATUS='SUCCESS';
        RETURN TRUE;
      END;

      CREATE PROCEDURE CopyMessageHeaders() BEGIN
        DECLARE I INTEGER 1;
        DECLARE J INTEGER;
        SET J = CARDINALITY(InputRoot.*[]);
        WHILE I < J DO
        SET OutputRoot.*[I] = InputRoot.*[I];
        SET I = I + 1;
        END WHILE;
      END;

      CREATE PROCEDURE CopyEntireMessage() BEGIN
        SET OutputRoot = InputRoot;
      END;
        END MODULE;