Cannot dbms_output.put_line after changing container
Hi
Oracle 19c
I have cdb and single pdb named pdb1
demo1.sql
set serveroutput on;--set verify off;begindbms_output.put_line('before');execute immediate 'alter session set container=&1';dbms_output.put_line('after');END;/exit;
$ sqlplus -s / as sysdba @demo2.sql pdb1old 3: execute immediate 'alter session set container=&1';new 3: execute immediate 'alter session set container=pdb1';PL/SQL procedure successfully completed.
When I comment or remove this execute immediate.
demo2.sql
set serveroutput on;--set verify off;begindbms_output.put_line('before');dbms_output.put_line('after');END;/exit;
$ sqlplus -s / as sysdba @demo1
0