# Debugging pipelined functions

**URL:** <https://forums.toadworld.com/t/debugging-pipelined-functions/39893>\
**Category:** Toad for Oracle - Beta\
**Created:** [August 22, 2017, 10:46am UTC](https://forums.toadworld.com/t/debugging-pipelined-functions/39893 "2017-08-22T10:46:57Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![crjohnso](https://avatars.discourse-cdn.com/v4/letter/c/67e7ee/32.png) [@crjohnso](https://forums.toadworld.com/u/crjohnso)\
**Post date:** [August 22, 2017, 10:46am UTC](https://forums.toadworld.com/t/debugging-pipelined-functions/39893/1 "2017-08-22T10:46:57Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![damir.vadas\_250](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/damir.vadas_250/32/37_2.png) [@damir.vadas\_250](https://forums.toadworld.com/u/damir.vadas_250)\
**Post date:** [August 23, 2017, 4:33am UTC](https://forums.toadworld.com/t/debugging-pipelined-functions/39893/2 "2017-08-23T04:33:39Z")

</div>

This is mine thread where I was able to do that  
[http://www.toadworld.com/products/toad-for-oracle/f/10/t/34025](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