Forum OpenACS Q&A: Response to executing remote sql from shell script

Collapse
2: Response to executing remote sql from shell script (response to 1)
Posted by Sebastiano Pilla on 09/11/02 09:42 AM
The SQL*Plus executable and the script must be on the same machine for this to work. So you can have:
  • telnet to the remote machine, execute the remote SQL*Plus program and call the script stored on the remote machine
  • execute your local SQL*Plus program, connect to the remote DB and call the script stored on your local machine