How to return an output parameter of type xmltype

[stephbzr]

Hello,

I need to get an output parameter of type xmltype from a PL/SQL procedure. Usually, I use tDBSP to execute a procedure and get my output parameter of type string, integer... and it works fine. But in my case, it's the first time that my output parameter of my procedure is of type xmltype. 

Here is what I need to get as output (an xml tag), I tested manually in Oracle before testing in Talend.

  But in Talend, I can't find any type that could match xmltype. Does anyone have an idea?

 

[Anonymous]

Hi

Can you try to select byte array (byte[]) as output type on the schema, and then create a new String with it on a tJavaRow:

ouput_row.v_res= new String(input_row.v_res);

Please try and let me know if it works.

Regards

Shong