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.