My Oracle Support Banner

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

Last updated on NOVEMBER 12, 2019

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

To view full details, 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 a vibrant support community of peers and Oracle experts.