2 Replies Latest reply: Oct 9, 2013 5:01 AM by Anindya Chatterjee RSS

    Special Character(&) Problem In OdiInvokeWebService As Input

    Anindya Chatterjee

      Hi,

       

      I'm invoking a SOA web service from ODI using OdiInvokeWebService tool.But ODI is unable to process the '&' symbol.Some times I thought it is the problem with ';' but later on I realize it is the problem with '&' sign you will understand from the test cases.

      Please Help.

       

      Thanks

      Anindya

       

      NB:-Please let me know if you need any more details.


      Test Cases


      STEP 1:-

       

      Original Input That needs To Be Provided To The Service:-

       

      MIS - APProjectProc&Spend-INC-Oracle R1213

       

       

      Out Put:-

       

      ODI-1226: Step OdiInvokeWebService 1 fails after 1 attempt(s).

      ODI-1241: Oracle Data Integrator tool execution fails.

      Caused By: com.sunopsis.wsinvocation.SnpsWSInvocationException: javax.xml.stream.XMLStreamException: Error at line:3 col:50 Line:3 ';' expected, got char[32]

       

      -----------------------------------------------------------------------

      STEP 2:-

       

      So Tried for Input:-

       

      MIS - APProjectProc&Spend-INC-Oracle R1213

       

      Out Put:- Spend-INC-Oracle R1213

       

       

      --------------------------------------------------------------------------

       

      STEP 3:-

       

      So Again Tried for Input:- 1234567;8

       

      Out Put:- 1234567;8

      ------------------------------------------------------------------------------

       

      STEP 4:-

       

      So Again Tried for Input:- MIS - APProjectProc&Spend-INC-Oracle R1213

       

      Out Put:- Spend-INC-Oracle R1213

       

      Out put means data sent to the webservice.