Sean, perhaps I am missing something from your question, but this sounds
like a job for Oracle Lite (whatever name the marketing folks call it now,
it used to be Oracle Lite anyway). I had an environment similar to your
scenario.... engineers in the field would use their laptops all day
scanning assets, etc. and then upload at night. They had a custom
application on their machine and it used the Oracle Lite platform with a
small database. This db was then synched over dialup each night with the
enterprise DB, then in the morning they dialed up and got the work orders
for the day. There were PL/SQL packages to check for integrity, etc.
Obviously, the next logical extension to this project could have been using
the Oracle Lite DB for Palms. In any case, look at the Oracle Lite
product for this functionality... it may be just what you need.
BTW, if you get a chance and have the time (hard to get I know), load the
Oracle Lite DB for Palms and play around w/ it.... it is really a neat
tool. It even has a little SQL interface to write queries on. Don't
know how well it scales but it is fun to mess around with.
HTH
John D.
"Thater,
William" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<ThaterW@tele cc:
rgy.net> Subject: Re: Batch updates
Sent by:
root@fatcity.
com
07/06/2001
12:06 PM
Please
respond to
ORACLE-L
"O'Neill, Sean" wrote:
>
> I'd appreciate hearing from folk what "solutions" there are for the
> following scenario. Users with laptops want to be able to input data
whilst
> not connected to database for subsequent upload to database. Apart from
> developing PL/SQL code to realise this functionality with associated
> integrity checks etc. are there other possible (3rd party) solutions?
replication to/from personal ORACLE? can you even do that? some 3rd
party software i've had experience with used sqlbase [i think] to move
stuff to/from a users laptop. [vantive for one.]
--
Bill "Shrek" Thater Certifiable ORACLE DBA
Telergy, Inc. [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
one ping to rule them all, one ping to find them, one ping to bring them
all, and in the darkness bind them.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thater, William
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
