FILE->WEBSERVICE->JDBC Sceanrio

[Former Member]

Hi All,

have file to webserivce sceanario

i am using this Webserice to insert the records into the oracle databse.(not using the JDBC recievr adapter because of some size limitations)..so i can only use websrivce for this to insert

Now the table has five columns field1 field2 field 3 input_xml and output xml

and webservice will insert the records into field 1 field 2 field 3 and input xml and output xml will be blank

Now i need invoke the javastored procedure by passing the value from field 1 from the record inserted along with some other parametes

this perticular java stored procedure will create output_xml in the output xml column and will be placed against the same record that was inserted from the webservice.

finally need to send this output xml back to the file systems.(sender)

currently i ahve configured the indivisual sceanrios one for webserivce and other for the invoking the stored procedure

i need to make club into a single sceanrio(FILE->WEBSERICE->INVOKE JAVA STORED PROCEDURE-SEND OUTPUT XML TO SENDER FIEL SYSTEM) where in after the webserivce has inserte the record successfully,need to invoke the java stored procedure and send the output XML back to the sender(file system)

is this possible w/o using BPM.?

if i have to use BPM..what will be steps in the integration processa nd the the ID.

[stefan_grube]

> is this possible w/o using BPM.?

No, this is not possible without BPM.

> if i have to use BPM..what will be steps in the integration processa nd the the ID.

search for related weblogs