Share this page

# 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.`

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: