I use a few different tools for testing databases and testing the packages and
the API’s that are created.
I really do like Toad, except for one key area. This is the ability to test an
API quick and easy.
I have yet to find a real good easy way to do this in Toad, but in PL/SQL
Developer I do it as follows.
I find the API, it may be a stand alone or in a package.
Then I right clink on the API
In the context menu I select Test
This in turn shows me a test window, and here I enter in my input data
I exec the API
Then in the test with I can also see the cursor and view the data.
It is so easy to do, and with the power that Toad has in some many other areas I
find it hard to believe that testing should be so hard.
I am not wanting to alter the code as this is always a pain point for QA, do not
alter the code
Any thoughts ?
Thanks for your time