SQL*Plus (MOSC)

MOSC Banner

How to remove system generated message?

edited Sep 1, 2010 7:43PM in SQL*Plus (MOSC) 11 commentsAnswered
Hi, I use "Spool" to output the report to a file and my SQL statements contained "Accept.....Prompt".  How can I remove the message I highlighted below from the spooled file?

Thanks.

Veronica

SQL> /
old 148:       ((p."Unit"='Month' AND (ADD_MONTHS(p.pdduedt,x.nb - 1) >= '&SDATE' AND ADD_MONTH
new 148:       ((p."Unit"='Month' AND (ADD_MONTHS(p.pdduedt,x.nb - 1) >= '01-aug-2010' AND ADD_
old 149:        (p."Unit"='Year'  AND (ADD_MONTHS(p.pdduedt,12*(x.nb-1)) >= '&SDATE' AND ADD_MO
new 149:        (p."Unit"='Year'  AND (ADD_MONTHS(p.pdduedt,12*(x.nb-1)) >= '01-aug-2010' AND A

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center