Loading

Web Service

Radiant Software

11y1.1k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

murat yalniz11y ago
http://www.webservicex.net/ws/WSDetails.aspx?CATID=2&WSID=70 How to use?
Manas Mohapatra11y ago
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.