Is it possible to use StoredProcedurewithSignature to get output from multiple tables and map it in a structured webMethods document type in a single stored procedure.
e.g. A Header record which has say few columns and under that header there are several detail records with multiple columns.
Can we pass a single key value to a stored procedure which will query all the orders associated with that key and all the detail lines associated with each of the orders AND map the output in a webMethods document type. In pipeline when u view the webMethods document types you should say each order and its corresponding lines in hierarchical structure.
Can some one give the hints or sample stored proc written for SQL server database. (Stored procs should be similar for SQL server and Oracle but still, if you have a choice pls send samples for SQL server database)