'Set Serveroutput On' Stops Working When Switch Containers using SQL*Plus
(Doc ID 3074477.1)
Last updated on FEBRUARY 28, 2025
Applies to:
SQL*Plus - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
On : 19.x version, SQL*Plus
ACTUAL BEHAVIOR
In SQL*Plus, SET SERVEROUTPUT ON stops working when you switch containers.
EXPECTED BEHAVIOR
Expect SET SERVEROUTPUT ON to still work after switching to PDB.
It is observed that when doing a "show serveroutput", it does say ON even after "alter session"; yet it does not show output when doing dbms_output. It shows only after repeating SET SERVEROUTPUT ON command.
STEPS TO REPRODUCE:
The issue can be reproduced at will with the following steps:
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |