How to Suppress Messages in the Spool File when Asking for Data from User (Doc ID 222275.1)

Last updated on MAY 31, 2017

Applies to:

SQL*Plus - Version 8.0.6.0 and later
Information in this document applies to any platform.

Symptoms

You are using sqlplus to produce query results in spooled file.
On run time query ask user for some values.
The questions and substitution messages appear in spooled file.

For Example:
We have created a script file, as follows:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms