Skip to Main Content
Forums

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!

Debug "Table Function"

usman_noshahiJan 30 2016 — edited Feb 5 2016

Hi,

This question might be already on forum But I couldn't find anything regarding it.

My question is: How to debug table function.

For Example I have function in package

Function Get_States (P_Parameter_1 In Number , P_Parameter_2 In Number ) Return Collection_type Pipelined ;

And Inside the function I have some row piping algorithm lets say some calculations. When I try to debug it it gives me Error.

Sql_Error.PNG

Please guide me how to debug such Function.
This post has been answered by usman_noshahi on Feb 5 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2016
Added on Jan 30 2016
#sql-developer
2 comments
1,115 views