cancel
Showing results for 
Search instead for 
Did you mean: 

XI output as a blob or single string

Former Member
0 Kudos

Hi All,

Is there a way in XI to make the output xml generated after mapping as a single String or blob.

Example:

if the output is

<?xml version="1.0" encoding="UTF-8"?>

<Emp_Target_MT>

<Emp_Id>1</Emp_Id>

<Emp_Name>ba</Emp_Name>

</Emp_Target_MT>

Can this output be made as a single string or blob?

the scenario is to generate the output xml and pass it on to an Oracle Stored Procedure which takes only one parameter as the entire output xml.

Regards,

Balaji.M

Accepted Solutions (1)

Accepted Solutions (1)

moorthy
Active Contributor
0 Kudos

Hi,

do u want the output with one string with xml tags ? Or just a value ?

If just a value, just concatenate into one field in the target during mapping and the send the data .

does it help?

Rgds,

Moorthy

Former Member
0 Kudos

Hi,

I will be using the JDBC Receiver adapter to call the SP in Oracle.

Krishna, I want the entire output with all the xml tags bundled into one string.

i should not be hardcoding the xml tags and concatinating the valus.

should be the entire xml output in one string

Regards,

Balaji.M

Former Member
0 Kudos

I think you need to write UDF for this. there is library from apache called XML Serializer. Below is the sample file how you achieve that using that. Use that code in your UDF.

http://www.informit.com/articles/article.asp?p=31349&seqNum=3&rl=1

--Archana

Former Member
0 Kudos

Balaji,

Have you seen this weblog which may help you:

/people/michal.krawczyk2/blog/2005/11/01/xi-xml-node-into-a-string-with-graphical-mapping

---Satish

Answers (1)

Answers (1)

0 Kudos

Hi

which receiver adapter will you use?

Regards

J.