on 10-26-2006 5:43 PM
hi,
Based on the call from webservice I need to select data from two tables and send back. Expected output is one row from one table and multiple rows from the other. So I created a structure as shown:
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_DB_PS_Req xmlns:ns0="http://timken.com/poc/webservices">
- <Statement>
- <Table action="SELECT">
<table>poc.order_operation</table>
- <access>
<plant />
<work_center_id />
<work_center />
<operation_status />
<material_produced />
<order_quantity />
<quantity_uom />
<quantity_completed />
<quantity_scrapped />
<activity />
<std_activity_quantity />
<actual_activity_quantity />
<activity_quantity_uom />
<activity_start_time />
<activity_end_time />
<description />
</access>
- <key>
<order_number>String</order_number>
<operation_id>String</operation_id>
<routing_seq_num>int</routing_seq_num>
</key>
</Table>
</Statement>
- <Statement1>
- <Table action="SELECT">
<table>poc.operation_material</table>
- <access>
<material_id />
<material_source />
<std_material_usage />
<actual_material_usage />
<usage_uom />
</access>
- <key1>
<order_number>String</order_number>
<operation_id>String</operation_id>
<routing_seq_num>int</routing_seq_num>
</key1>
</Table>
</Statement1>
</ns0:MT_DB_PS_Req>
I am unable to get any output. When I check in RWB the ouptput is shown as:
<?xml version="1.0" encoding="utf-8" ?>
- <ns0:MT_DB_PS_Req_response xmlns:ns0="http://timken.com/poc/webservices">
<Statement_response />
<Statement1_response />
</ns0:MT_DB_PS_Req_response>
Can someone help me with this.
thank you
Hi,
Check if the Response Messge Type is of this format.
<?xml version="1.0" encoding="UTF-8" ?>
- <ns0:MT_DB_PS_Req<b>_response</b> xmlns:ns0="http://timken.com/poc/webservices">
<Statement<b>_response</b>>
<b><row></b>
<plant />
<work_center_id />
<work_center />
<operation_status />
<material_produced />
<order_quantity />
<quantity_uom />
<quantity_completed />
<quantity_scrapped />
<activity />
<std_activity_quantity />
<actual_activity_quantity />
<activity_quantity_uom />
<activity_start_time />
<activity_end_time />
<description />
<b></row></b>
</Statement<b>_response</b>>
<Statement1<b>_response</b>>
<b><row></b>
<material_id />
<material_source />
<std_material_usage />
<actual_material_usage />
<usage_uom />
</row>
</Statement1<b>_response</b>>
</ns0:MT_DB_PS_Req>
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI,
CHeck this blog for message type structure etc-
/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step
First try to get the output for one table - to debug,
Hope this helps,
Regards,
Moorthy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi raj,
1) Check whether the Table has the values,
2) use occurance 0:unbounded for access element.
3)Whether the Table has many records..and not Indexed.
http://help.sap.com/saphelp_erp2004/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm
Regards
Agasthur iDoss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.