Debugging pipelined functions

Consider this simple example:

CREATE OR REPLACE PACKAGE debug_test AS

TYPE type_rec IS RECORD(date_val DATE);

TYPE type_coll IS TABLE OF type_rec;

FUNCTION return_pipe

RETURN type_coll

PIPELINED;

END;

/

CREATE OR REPLACE PACKAGE BODY debug_test AS

FUNCTION return_pipe

RETURN type_coll

PIPELINED AS

v_rec type_rec;

v_date DATE;

BEGIN

SELECT SYSDATE INTO v_rec.date_val FROM DUAL;

PIPE ROW (v_rec);

END;

END;

/

If you create the package and execute –

select * from table(debug_test.return_pipe);

It works fine. If you try to step into the debugger you will get a probe timeout and

Chris Johnson

IT Systems Analyst

Distribution Logistics

615-855-4371

This is mine thread where I was able to do that
http://www.toadworld.com/products/toad-for-oracle/f/10/t/34025
but I asked why default proposed Toad way is not working.
How ever, you described pretty detailed answer to your question “how to”.

Hope this helps,

Cheers

Damir