How to Suppress Messages in the Spool File when Asking for Data from User
(Doc ID 222275.1)
Last updated on MAY 30, 2023
Applies to:
SQL*Plus - Version 8.0.6.0 and laterInformation 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! |