Oracle Database Lite for WinCE

Tutorial for Building Mobile Applications for Windows CE 20-1

20

Tutorial for Building Mobile Applications for

Windows CE

You can implement Mobile applications with Oracle Database Lite for WinCE. Oracle

Database Lite supports various application models for the Windows Mobile/Pocket

PC device, such as ODBC, JDBC, and ADO.NET. When developing your own WinCE

application, you can use Visual Studio 2005.

This chapter uses a tutorial to demonstrate how to create, deploy, administer, and use

20.1 Overview of the WinCE Sample Application

The sample WinCE application details typical activities of delivery personnel in the

Transportation and Logistics industry, which includes package pick-up and delivery.

1. Before he leaves the dispatch center, the delivery person collects the complete

delivery package list and the package delivery destination information for the day

development computer and the client device meet the requirements specified below.

20-2 Oracle Database Lite Developer’s Guide

client for Pocket PC on the device. For more information on how to install the Mobile

To develop and test the WinCE Transport application, perform the following tasks.

1. Section 20.2.1, "Create Database Objects in the Oracle Server"

2. Section 20.2.2, "Write the Application Code"

3. Section 20.2.3, "Compile the Application"

database in the client device along with the requisite tables and data. To publish the

application, users must create the database objects used by the application in the

Tutorial for Building Mobile Applications for Windows CE 20-3

database objects in the back-end. However, if the master schema is already created,

then remove the statements that create this schema from the create.sql script.

Table 20–3 Routes Table

20-4 Oracle Database Lite Developer’s Guide

Where:

Connect sub-routine in the transport.vb module establishes a connection to the

local Oracle Lite database with the DSN transport; the Disconnect sub-routine

releases the connection.