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.
CREATE COMPUTE MODULE SimpleDB_mf_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
-- CALL CopyEntireMessage();
INSERT INTO Database.dkralj.emp VALUES(InputRoot.XMLNSC.emp.name);
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;
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = InputRoot;
Made a simple message flow with MQ Input and Output and Compute node in which is ESQL node
Does this have anything to do with Apex at all?
Anyway, sounds like a character set mismatch. Check the character sets of IBM, your XE database and the XML file. And then move on to ask this in the database forum.