Run an SQL Script with SQL*Plus on a Windows System
If your OpenText PPM instance is running on a Windows system, and you are using the SQL*Plus utility to run an SQL script, the utility "expects" to get the exact number of parameters defined in the script. Some versions of SQL*Plus ignore null command-line parameters and get hung up waiting for missing parameter values.
Example
In the following line, the second parameter is null. But, because SQL*Plus is a command-line utility, it waits for the user to input the second parameter value.
ppm/ppm@ppm10a @somescript.sql "Y" ""
To work around this problem, add the following to the server.conf
file:
SQLPLUS_VERSION=<SQL_Plus_Version_Number>
A valid version number is 90101.