SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer 19.4: dbms output not working with SELECT...FROM pipelined function

JJP BENov 30 2020

Dears,
I have a PL/SQL pipelined function in a package, with some dbms_output.put_line instructions. The text is generated in TOAD without any issue when I do a SELECT t.* FROM TABLE(function)....
In SQL Developer 19.4, I open the dbms output window, press the green cross and select the connection I use for the SQL worksheet. Then I run the SELECT but nothing appears in the dbms output window. If I run in the same worksheet something like "BEGIN DBMS_OUTPUT.PUT_LINE('whatever'), END;"
then I get both!
Is this a known behaviour? Is it solved in the release 20.x?

This post has been answered by thatJeffSmith-Oracle on Nov 30 2020

Jump to Answer

Added on Nov 30 2020

#sql-developer

2 comments

1,242 views