PL/SQL (MOSC)

MOSC Banner

Cannot dbms_output.put_line after changing container

edited Sep 24, 2020 6:50AM in PL/SQL (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center