Are you saying that you want the entire application, including the Oracle database, to installed on the customer's PC as a stand-alone application?

If that is true, then I have to ask why are you using Oracle? It would seem to me (and I have done a lot of VB6/Oracle work) that you don't have a requirement for Oracle's power and complexity.

In that case, why not use Access or SQL Server, which might better suit the small scale application?