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.

Please guide me how to debug such Function.

This post has been answered by usman_noshahi on Feb 5 2016

Jump to Answer

The Explorer

Hi,
Please make sure that listener has been started and you are able to tnsping it.
Thanks

EdStevens

Well, he did say
After trying to start the listener, i am getting the error
Failed to start listener service, error 2: The system cannot find the file specified.

EdStevens

So the first thing seems to be to get your listener started.
What OS is the database installed on?
From the database server, show us the contents of 'listener.ora' and 'sqlnet.ora'. When you post it, please format it as 'code'. (https://community.oracle.com/tech/apps-infra/kb/articles/12-format-text)

1 - 3

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2016

Added on Jan 30 2016

#sql-developer

2 comments

1,121 views

SQL Developer

Debug "Table Function"

Comments

Post Details