Home -> Usenet -> comp.databases.oracle -> HELP: SQL*Plus, SQL*Loader - invoke from VB ??

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