Features and Benefits

According to the National Institute of Standards and Technology, software bugs cost IT organizations almost $60 billion annually. Bugs often occur as a result of functional errors in the underlying database code and many are not discovered until end users are negatively impacted by them.

For Developers

By automating the test process, Code Tester for Oracle helps you quickly build tests for both existing and new programs. These tests can be run as you develop your code and as regression tests before the code enters production, ensuring that your programs will remain free of bugs throughout their years of use and maintenance.

Here's how Code Tester revolutionizes the PL/SQL testing experience:

• Rather than writing lengthy test scripts, you describe the required tests or expected behavior of the program through an intuitive graphical interface
• Code Tester then generates a PL/SQL test package that exercises programs according to the inputs you have provided
• You can run your tests through the user interface (as an aid to development) and in batch mode (regression testing) via a command line interface
• Code Tester automatically verifies the results and displays them in an intuitive “red-light, green-light” (pass/fail) Results Viewer -- you can also ask Code Tester to generate code profiling data, from which you can produce code coverage reports
• Test definitions and results are stored in a repository (Oracle backend), from which you can generate reports and analyze the quality and quantity of testing

For Technical Leads and Development Managers

Without an automated testing tool, it is very difficult to determine if a program has been adequately tested and almost impossible to be confident that an entire application code base is "ready for prime time." Code Tester for Oracle takes the guess work out of this process by providing technical leads and development managers with an objective view of the application's testing status.

When your developers use Code Tester, you will be able to:

• Leverage an Oracle-based test repository and built-in reports to identify which programs have been tested and how thoroughly tests have been conducted
• Improve end user satisfaction and shorten QA and user acceptance cycles as a result of more errors being exposed earlier, during development, when they can be fixed more easily and at a lower cost
• Dramatically reduce maintenance costs of applications once they are deployed to production
• Automated execution of an extensive battery of regression tests thoroughly exercise backend PL/SQL code, quickly identifying any bugs that have crept into the code base
   

  Download Trial

  Product components include:

  Test Dashboard Intuitive visual interface offers "at a glance" test status Execute tests with the click of a button Work with programs in multiple schemas Export and import test definitions Organize tests within Test Suites	Test Builder At-a-glance visual console to define test cases and outcomes Document test cases to ease maintenance of tests Provide setup and teardown logic at all levels of test definition Choose from over 170 distinct tests, allowing easy testing of tables, cursor variables, collections, and more Define dynamic test cases based on pre-defined or query-driven test data values Take advantage of over 60 predefined Quick Build test templates Automatic validation of test case definitions
  Test Data Manager Build tests based on pre-defined, commonly used test data values Code Tester ships with over 40 built-in test groups, such as: delimited list variations, typical boundary conditions for various scalar types, social security formats, and groups of related exceptions. Add your own domain and application specific test data group Define a group based on queries against existing test data tables.	Quick Builds Take advantage of over 60 predefined Quick Build test templates Guides developers to common tests for various scenarios. Example for DELETE operations: Did a table row deletion fail due to ORA-2266 (FK exception)? The table has not changed at all The count of rows in the TABLE is unchanged Was the -02266 exception raised? Simple drag and drop of templates to jump-start testing Search Quick Build templates by keyword
  Reporter Code Coverage reports Code Status reports Filter by user Exclude packages View in BMP, TIFF, JPEG, RTF, HTML, PDF, Excel	Miscellaneous Test code is implemented in PL/SQL - not a black box solution! Integrate test execution into scheduled and continuous build environments Uses Quest's powerful SQL & PL/SQL Formatter Generate test code to display output through DBMS_OUTPUT instead of UI