I have a Procedure with Two Out parameter of table type. I am using DB Adapter to fetch these two out parameter. One out is for Header rows and other out is for detail rows. The strange thing is that when I test this composite using SOA server i only get data from header table but no data from detail table. My Procedure is fine when i run in SQL developer. It gives data for both tables. One another thing that i already created same composite for two other master and detail tables and that is working really fine. I tried every trick but could not get any success in this composite. Kindly help me to point out any error.
Thanks a lot
Thanks Vijay for respond..
I am not using any transformation or Mapping. I configured a DB Adapter first. Then make a BPEL Process having input and output according to DB Adapter XSD file. then i just invoked and copied the output of procedure to output of payload.
Use a trace session in /em to monitor the DB Adapter at the finest level. It will show what goes to the DB and what comes back from the DB. There you should be able to see what params&values go in and come back from DB. What does the stored proc params header () look like? Did the output params show up correctly when you chose the stored proc from the DB Adapter wizard through stored proc option?
thanks a lot for replying. Actually i have solved this problem but could not update here. The problem was in my Wrapper package, When i used DB Adapter it created a Wrapper Package in DB but with error. After some modification in Procedure the problem were gone.