1 Reply Latest reply: Nov 18, 2012 4:12 AM by Hoek RSS

    Oracle PL/SQL package debugging and unit testing

    959687
      I am newly changed the technology into oracle PL/SQL developer, In that i have to unit test the complete the full package and have to find the where the data is not generated correctly and where the calculation is wrong, so for i have to write logic, but i dont no how to start debug and how to give input, i have difficulty what are the steps to followed to start testing..and i am working in stock exchange project.. anybody help me out how to start testing and debugging the package.. Thank you for your favorable reply in advance..
        • 1. Re: Oracle PL/SQL package debugging and unit testing
          Hoek
          If you're using PL/SQL Developer, then check the help file.
          You can test your package using a test window and/or the debugger that comes along with PL/SQL Developer..
          How it works is explained in the help file.
          It is important that before you start debugging, you have several test scenario's written out, containing the various inputs and expected outputs, based on the business rules that apply per case.
          Also it doesn't hurt to read about 'instrumentation code', in order to see how your package executes.
          You can search on http://asktom.oracle.com to find out more, using such an approach.
          Here's an introduction:
          http://tkyte.blogspot.nl/2005/06/instrumentation.html
          And while we're at it, and you're new to Oracle, you might want to read:
          http://tkyte.blogspot.nl/2012/08/the-keys-to-oracle.html

          edit
          And if you mean SQL Developer (free, from Oracle) instead of PL/SQL Developer (not free, from Allround Automations)
          then check out the SQL Developer forum @ SQL Developer

          Edited by: Hoek on Nov 18, 2012 11:10 AM