2 Replies Latest reply: Dec 13, 2012 6:50 AM by 964347 RSS

    How to send 'empty space' to the target DB in transformations in BPEL11g

      Hi All,

      We have migrated BPEL code from 10g to 11g, which used to run successfully by sending an 'empty space' to the target (Oracle Database). But this code, in 11g, fails at runtime stating the field cannot be empty, as it is considering the empty space to be null. We tried using ' ', the code runs successfully this time but while checking the DB we found that it has entered a junk character into the respective field.

      Please let us know how this can be achieved.


      Edited by: 976054 on Dec 10, 2012 12:00 PM