ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';

CREATE TABLE t (
    n NUMBER,
    c1 VARCHAR2(4000) DEFAULT rpad('X', 3999, 'X')
);

VARIABLE c1 VARCHAR2(4000)
ALTER SESSION SET EVENTS '10046 trace name context forever, level 8';
INSERT INTO t(n) VALUES(1);
INSERT INTO t(n) VALUES(1) RETURNING c1 INTO :c1;

VARIABLE n NUMBER
EXEC :n:=dbms_pipe.receive_message('some_pipe', 10)

variable x varchar2(4000)
begin
	select lpad(dummy,3999,'x') into :x from dual;
end;
/

