I have Visual Studio 2008(on the client machine) and Oracle 10g XE(on the server machine).

I want to access the Oracle Database on the server and populate the application on the Client through a web service.

The normal way is to create a .net service and attach it with Oracle. But I want to do it, the other way around i.e. I want to create an Oracle Web Service that could be attached in VS .net 2008 application(using add reference).

So can that be done?

Is there a way to create an oracle web service that could be used in .net? If yes, how does it happen?

Thanks and Regards