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