How to Suppress Messages in the Spool File when Asking for Data from User
Last updated on MAY 31, 2017
Applies to:SQL*Plus - Version 18.104.22.168 and later
Information in this document applies to any platform.
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.
We have created a script file, as follows:
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