Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

set feedback only error

T1DSoldierJan 17 2020 — edited Jan 21 2020

when trying to use SET FEEDBACK ONLY i keep getting the SP2-0268: feedback option not a valid number error. I am running 12.2 db and 12.1 client

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 17 07:58:14 2020

Last Successful login time: Fri Jan 17 2020 07:53:09 -05:00

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show feedback

FEEDBACK ON for 6 or more rows

SQL> set feedback only

SP2-0268: feedback option not a valid number

SQL> SET FEEDBACK ONLY

SP2-0268: feedback option not a valid number

SQL> set feedback on

SQL> set feedback only

SP2-0268: feedback option not a valid number

SQL> set feedback only 1

SP2-0268: feedback option not a valid number

SQL> set feedback 1 only

SP2-0158: unknown SET option "only"

SQL> set feedback

SQL> show feedback

feedback OFF

SQL> set feedback only

SP2-0268: feedback option not a valid number

SQL> set feedback 'only'

SP2-0268: feedback option not a valid number

any ideas?

Thanks

Dave

This post has been answered by Jonathan Lewis on Jan 17 2020

Jump to Answer

Added on Jan 17 2020

#database, #general-database-discussions

11 comments

1,072 views