Skip to Main Content
  • Questions
  • sqlplus 'set feedback off' is not working for oracle client 19.14 as expected.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Murat.

Asked: January 25, 2023 - 12:05 pm UTC

Last updated: January 31, 2023 - 7:27 am UTC

Version: 19.14

Viewed 1000+ times

You Asked

Hi Tom,

I have recently upgraded a couple of databases (12.1 -> 19.17) and remote oracle client (19.3 - 19.14 ) on application servers connecting upgraded databases.

There exist only one case where 'set feedback off' is not working as expected when I commit from sqlplus client 19.14 to only one of those upgraded 19.17 DBs.

How may I trace sqlplus to find out reason of unexpected behaviour for 'set feedback of'.

Here is the test case I produced.

#########Connect to a database ( test1 ) on the same db_host and using same db_oracle_home where "SET FEEDBACK OFF" is working as EXPECTED.

infa64@dwhsas15> sqlplus test_user@dwhpx-scan:1521/test1

SQL*Plus: Release 19.0.0.0.0 - Production on Mi Jan 25 09:47:34 2023
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle. All rights reserved.

Kennwort eingeben:
Letzte erfolgreiche Anmeldezeit: Mi Jan 25 2023 09:46:38 +01:00

Verbunden mit:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> commit;

Transaktion mit COMMIT abgeschlossen.

SQL> set feedback off
SQL> commit;
SQL> exit
Verbindung zu Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0 beendet



#########Connect to a different database ( test2 ) on the same db_host and using same db_oracle_home where "SET FEEDBACK OFF" is NOT working as EXPECTED.

infa64@dwhsas15> sqlplus test_user@dwhpx-scan:1521/sim

SQL*Plus: Release 19.0.0.0.0 - Production on Mi Jan 25 09:48:01 2023
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle. All rights reserved.

Kennwort eingeben:
Letzte erfolgreiche Anmeldezeit: Mi Jan 25 2023 06:01:50 +01:00

Verbunden mit:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.17.0.0.0

SQL> commit;

Transaktion mit COMMIT abgeschlossen.

SQL> set feedback off
SQL> commit;

Transaktion mit COMMIT abgeschlossen. --<< UNEXPECTED >>--

SQL>

and Connor said...

I can't reproduce but I don't have the exact server/client version combination you have.

It does seem very strange.

I would recommend logging an SR on this one, but also (for your own peace of mind) try some of the instantclient downloads ( https://www.oracle.com/cis/database/technologies/instant-client/downloads.html ) and see if certain permutations do (or do not) show the issue.

You may have hit a bug on a particular client/server patch level mix.

Is this answer out of date? If it is, please let us know via a Comment