Web Service

Question

Can we create a web service which will insert data into two mysql database table at a single web method???

murat yalniz · Answer

http://www.webservicex.net/ws/WSDetails.aspx?CATID=2&WSID=70 How to use?

Manas Mohapatra · Answer

Hi Dnyanu I am writing how you can accomplish to hit two databases at a time. Process: Create a stored procedure(SP1) in one mysql database(db1). In SP1 you call another store procedure with passing required parameter. CALL db2.proc2(@a); Here db2 is another database name and proc2 is stored procedure present in db2. From your code(webservice) you need call SP1 which is present db1 and SP1 will call SP2 inside it.