This discussion is archived
2 Replies Latest reply: Dec 13, 2012 4:50 AM by 964347 RSS

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

979057 Newbie
Currently Being Moderated
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.

Thanks

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points