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

Posted by Sebastiano Pilla on
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