This discussion is archived
0 Replies Latest reply: Apr 3, 2012 9:45 AM by 928270 RSS

calling a DB function by passing variable's value at runtime

928270 Newbie
Currently Being Moderated
hi all,

there is requirement that i need to call a DB function which takes NUMBER as input and returns varchar2, is there any way to pass the value from variable to function's input through service callout. I am trying to call the functinon by passing variable's value by doing replace activity in body but function is called with null as input, always.

because i am reading the data from the queue de to which the schema is not known for the data from queue, so cannot use Xquery.

Please help me out

Legend

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