Hi All,
I have a situation where I need to access both SQL and Webservice from a single query.
This is how it looks,
select gene_name, protein_name from Gene,Protein
Client will send this query to my middle Tier.
Here Gene table is in the Oracle , but Protein is not with us. I have to make a webservice call to get the Protein result from some other institution.
Please suggest me an efficient way to do it.
Thanks
Varnika