Oracle connectivity

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Me (Me_at_somewhere.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 23:20:16 +1030

Evening all

I am trying to work out the best way to communicate with an Oracle database
from a .Net CF application. My main requirements are to be able to:

- Execute an Oracle PL/SQL stored procedure designed to return simple/scalar
values.
- Execute an Oracle PL/SQL stored procedure designed to return a
dataset/datatable (via a Ref Cursor).
- Execute an Oracle PL/SQL stored procedure designed to perform
updates/Inserts. In this case the client application will have to forward a
data structure containing all of the field values for a particular record.

All of the database I/O logic is to be encapsulated inside the stored
procedures. Note that there is no need for direct access to database tables.
The dataset will only be used for browse/display purposes.

As it is, remarkably, there are *no* Oracle data providers for .Net CF
applications. So, I am looking for the next best alternative and I am hoping
to develop a solution that will be host platform independent.

So far I know of two possible options:

1)
Write a Web Service, most likely of the XML variety, to run on the host. The
Web Service receives requests from the client .Net CF application and
processes them by executing the appropriate stored procedure(s) and if
necessary, returning data to the client.

2) Create a set of COM "wrapper" classes to be deployed on a middle tier.
The client application can then use these COM objects to perform the
required stored procedure calls and data transfer functions.

In any case:

What development tool(s) / languages(s) would be the most likely to provide
for the goal of platform independence?

Are there any solutions available in the marketplace that can be adapted to
meet specific requirements? eg A web service containing stored procedure
calls. A .Net CF application using the web service.

Does anyone have a preferred solution and if so what are your reasons?

Thanks for your help

Deej

Relevant Pages

  • Re: WebServices and Datasets
    ... And if I call the GetChanges Method on the dataset that only the ... be shown in the dataset and to pass that to the web service, ... "Now to make sure the remote database is updated with changes should I ... client a change as occurred unless the client is constantly polling it. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Recordsource only available to Administrator on clients
    ... Do your users have the right to access this second database? ... On the SBS machine as well as the clients, ... to temporarily set a client user's privileges from, ... parameterized stored procedure, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: WebServices and Datasets
    ... > be shown in the dataset and to pass that to the web service, ... > well ther GetChanges method creates a new dataset object with only rows ... > "Now to make sure the remote database is updated with changes should I ... > client a change as occurred unless the client is constantly polling it. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: Recordsource only available to Administrator on clients
    ... if in the ADP all database items appear ... are you able to double-click and execute the uspPT stored procedure from ... Server instance is readily connected via SSMSE (Server type: Database ... to temporarily set a client user's privileges from, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: How to handle concurrency issue with better performance?
    ... Would you put the timestamp check in the stored procedure on the server ... that have been modified since they were pulled from the database. ... select command). ... client) downgrade very much in using such ...
    (microsoft.public.dotnet.framework.adonet)