I suppose that you want to generate the SOAP request dynamically.Is your purpose is to call the WSDL (not populating the WSDL I suppose ) ?.
can you please elaborate ? I have a suggestion towards your problem
Thanks for the reply.
I have to invoke the wsdl file and was able to pass the records manually and even tried with XML file and succeeded once.
So going further I will have to automate the process as this XML has to be truncate and load type ... another catch is I will have to capture the rejected records as well (for this im gonna load data into temp table which vll reject the duplicate records based on the comp PK)
let me know if more information is required
Reverse engineer the XSD(or XML) with the SOAP envelope and populate the generated schema tables using IKM XML Control Append.Now synchronize the table with the XML file. After the XML is populated with the values it can be used as a source for the OdiInvokeWebservice tool.
The flow control could be used to reject the records using this IKM itself.
Thanks for your reply, I've been trying the same as I mentioned in me first post itself.
But I am stuck with the XML load itself... it has got around 15 to 18 elements/tags and 5 extra elements like LoadDate,Message,Source like that which holds default data (standard)
I followed the link : https://s3.amazonaws.com/Ora/XML_5_db_to_Complex_XML.swf, but still confused as the Interface i failing at those 5 element mappings.
The package ran fine but the XML doesnt hold data, the individual datastores has data when checked under the Models.
1 person found this helpful
i think the synschronize step is missing thats why the data is in the schema and not in the XML.
Use the synchronize command,
SYNCHRONIZE [ALL | SCHEMA <schema_name>] [FROM FILE/FROM DATABASE]