debugging dbms_pipe package is full

[stef]

Hi

Overall does also not work by me in Version 12
Now 13.0.0.1874

* DBMS Pipe error when executing query inside debugging.
Also after cleaning up does give same error and again couple of records created

rg
Stefan

 

[Marco Kalter]

Can you provide some more details?

 

[stef]

Sure sorry for the delay

The problem occurs inside debugging when I execute sql inside debugging.
I get a DBMS pipe error and need to clear the pipe buffer:

After clearing it is also not working, but not always.

select * from v$db_pipes;

DECLARE
v_pipe_rm NUMBER;
BEGIN
DBMS_PIPE.PURGE('0048D82B0001$PLS_TO_DE');
v_pipe_rm := DBMS_PIPE.REMOVE_PIPE('0048D82B0001$PLS_TO_DE');
DBMS_PIPE.RESET_BUFFER;
dbms_output.put_line ( v_pipe_rm);
exception
when others then dbms_output.put_line ( SQLERRM ) ;
END;

Strange thing is that I want to reproduce, but for now, it is working.

:-( and I don't know why....Maybe you have any idea

regards,

Stef