Oracle 23c SET ERRORDETAILS on

SET ERRORDETAILS on




SQL> SET ERRORDETAILS on
SQL> conn /@FREEPDB1 as sysdba
ERROR:
ORA-01017: invalid credential or not authorized; logon denied
Help: https://docs.oracle.com/error-help/db/ora-01017/    <<<< to trun off this 




SQL> SET ERRORDETAILS off
SQL> conn /@FREEPDB1 as sysdba
ERROR:
ORA-01017: invalid credential or not authorized; logon denied


Warning: You are no longer connected to ORACLE.
SQL>


******

https://docs.oracle.com/en/database/oracle/oracle-database/23/sqpug/sqlplus-users-guide-and-reference.pdf   pageno 266  !!!!

In the following example, the variable ERRORDETAILS is set to ON:
SET ERRORDETAILS ON
SELECT * FROM EMP;
SP2-0640: Not connected
Help: https://docs.oracle.com/error-help/db/sp2-0640/