HELP: SQL*Plus, SQL*Loader - invoke from VB ??

From: Dale <dale_at_fox.nstn.ca>
Date: 1996/04/14
Message-ID: <4kpp3s$iok_at_news.nstn.ca>#1/1


I posted this about a week ago and got no response. Please help me with this one.

I have a VB application that uses needs to transfer data between the Laptop (running Personal Oracle7) to the Workgroup Server (running Oracle Workgroup Server)

I would like to automate as much as possible the extraction and update of data between the laptop and workgroup server. I would prefer to have a VB module (or menu option) that can invoke the data transfer process.

I also need to do the same for laptop backups of data collected (in case of accident, etc).

  1. Can this be done ?? (IE invoke SQL*loader or SQL*Plus from VB 3.0 )
  2. I also considered using SQL*Plus to copy updated records to identical tables owned by an "exchange" user and using Export / Import to transfer them.
  3. Any other suggestions on how we can do this ???

TIA
Babette Dale Underwood (dale_at_fox.nstn.ca) Received on Sun Apr 14 1996 - 00:00:00 CEST

Original text of this message