Debug a function.

[fidelfs]

I have a package with function and procedures. When I right click any function the test option is not available?

How can I test it?

I am using the trial version for Release 6.0

 

[oghislain]

Have you try to open a test window,
then copy/paste your code into it ?

 

[fidelfs]

Yes, I did. It works but I mean the right click menu is not working. It does not recognize the function for test.

 

[Marco Kalter]

The test function is only available for program units that are declared in the package specification. Private program units cannot be tested. Could this explain the issue?

Also note that the package specification must be valid.

 

[fidelfs]

Marco,

You just hit the nail on the head. The function is private so Pl/SQL can not test it.

Thanks,

 

[KFlash]

This should not be a problem.

To test a private function the PL/SQL developer has to do the following things (automaticly):
1: Create an unique package identifier (UPID)
2: Copy the whole package to a new one named [UPID]
3: Locate a possible forward declaration of the function to test and comment it out.
4: Create a entry in the specification of the new package.
5: compile the package.
6: Start the test
7: After ending the test, remove package [UPID] from the Database.

It is not a one line-of-code change, but it's worth to do it, because we have to do those changes manually to test them.