We are in the process of writing an application in C#. Currently, using ADO, we can do batch updates to Oracle. However, ultimately we would like to do a real time interface.

For example, from an Oracle Form, access the application to verify and return data. The Form could be served from a server or be web based, The database could be on a Unix, VMS or NT box. The application would be on the server.

Recommendations on best way to accomplish this... Foreign Function Interface? Java? ...