Notice: quest.com will be retired soon. Please visit our new site at software.dell.com
Toad World adds value to your Toad experience by providing free education and revealing new functionalities — along with
time-saving tricks and tips.
Visit the community »

White Paper

PL/SQL evangelist Steven Feuerstein reveals three fundamental criteria — and how you can meet them — to make any application a success.

Read now »

Quest Support
  • Global Coverage
  • Highly Skilled Engineers
  • Commitment to Customer Satisfaction
  • Flexible Support Offerings
Learn more »
Tech Brief
In this technical brief, John Weathington, President and CEO of Excellent Management Systems, Inc., explores Toad® Development Suite and Oracle’s SQL Developer.
Read now »

Code Tester for Oracle

Automate PL/SQL Code Testing and Eliminate Costly Bugs

Quest Code Tester for Oracle – a component of the Toad Development Suite for Oracle – is the first and only automated PL/SQL code-testing tool available. Created by one of the world’s most prominent Oracle PL/SQL experts, Steven Feuerstein, it provides an efficient and reliable way to perform thorough PL/SQL code tests. With Code Tester for Oracle, you can easily eliminate costly bugs and functional errors. It enables you to create elaborate regression tests to run as part of an automation script or to verify that any revised code is correct. The testing allows you to make changes with confidence, even if you’re unfamiliar with the code. Code Tester for Oracle lets you deploy high-quality code to production and reduce the total cost of ownership of your Oracle database management system.

Features

If you’re a developer, Quest Code Tester for Oracle helps you: 

  • Define tests quickly by simply describing the correct behavior and responsiveness of your projects without writing a single line of code
  • Execute tests with the press of a button for individual programs and test suites
  • Isolate and fix bugs rapidly
  • Customize testing options and save them
  • Recall tests whenever they need to be run
  • Manage nested suites with minimal effort
  • Create more than one test definition for the same program unit
  • Build a reputation for developing reliable, high-quality software

If you’re a development manager or an IT manager, Quest Code Tester for Oracle helps you:

  • Reduce the costs of maintaining applications
  • Understand the application’s quality
  • Implement a complete test plan before a single line of code is written
  • Run reports that analyze the test status of both individual programs and the entire application
  • Meet deadlines for application rollouts with confidence

Test Explorer – From this main screen, you can view the state of the code from a high level as well as run individual tests and suites of tests. Plus, you can instantly see the status of all your programs – whether they are valid, whether the associated test-case evaluations are true, and which units have problems. The Test Explorer groups related tests into a suite, making it easier to run those tests as needed.

Test Builder – With this intuitive interface, you can define and build tests. Plus, you can describe desired tests and the expected outcomes. Test Builder quickly creates more than 60 complex test scenarios for you. It constructs better code by providing a list of pre-defined, common tasks required for a given activity.

Test Reporter – Use this rich reporting interface to build reports on test cases for insight on test results and the development process. Whether you choose to display information in PDF, HTML, RTF, Excel, or image format, your team can quickly determine the level of code coverage and see which units pass or fail the existing set of test definitions.

Sys Reqs

Before installing Quest Code Tester for Oracle, ensure your system meets the following minimum hardware and software requirements:

Platform1.0 GHz x86 compatible CPU
Memory512 MB of RAM recommended
Hard Disk Space40 MB of disk space for installation
Operating SystemMicrosoft Windows 2000 Professional Edition (Service Pack 4)
Microsoft Windows XP 32-bit (Service Pack 2 or later) and 64-bit (x64; All Service Packs)
Microsoft Windows Server 2003 32-bit and 64-bit (Service Pack 1 or later)
Microsoft Windows Vista 32-bit and 64-bit (All Service Packs)
Microsoft Windows Server 2008 32-bit and 64-bit (All Service Packs)
Microsoft Windows 7 32-bit (All Service Packs)
Microsoft Windows 7 64-bit (All Service Packs)
Database ClientOracle SQL Net 9
Oracle SQL Net 10
Oracle SQL Net 11, plus Instant Client
Note: For Oracle 64bit servers, 32bit client is required.
Note: Quest Code Tester for Oracle has been tested on Oracle Exadata 2.0 running Oracle database 11g R2.
Database Server9i Database Release 2 (9.2.0.6 or above), 10g R1, 10g R2, Oracle Express Edition, 11g R1, 11g R2
Cloud Database ServerOracle databases running on Amazon EC2.
Required Database PrivilegesThe schema in which you install Quest Code Tester must have these privileges:
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE TRIGGER
CREATE VIEW
CREATE TYPE
Note 1: Quest Code Tester will create a schema with the necessary privileges as part of the installation process, when the create new user and install into new user schema option is selected on Step 2 of the Repository Wizard.
Note 2: We recommend that you install Quest Code Tester into its own schema, and create public synonyms so that all developers will be able to use Quest Code Tester and share their test definitions. This will also help you keep application code distinct from the Quest Code Tester code base. To do this, your schema must also have CREATE and DROP PUBLIC SYNONYM privileges.
Note 3: The Code Tester repository schema and any schema executing a test require the execute privilege on the DBMS_RANDOM package.

Virtualization Support

Before installing Quest Code Tester for Oracle, review the following for virtualization support:

ApplicationQuest Code Tester for Oracle has been tested with Quest vWorkspace 7.0.
Quest Code Tester for Oracle has been tested for Citrix XenApp 5.0 support on Windows Server 2003 (Service Pack 2) using the MetaFrame Presentation Server 4.0 and Citrix Presentation Server Clients 10.2.

Note: Code Tester may work in virtualization environments other than the ones in which it was tested.

 

Language Supported:

  • US English

Videos

Screenshots

Screenshot #2 Screenshot #3 Screenshot #4Screenshot #5 Screenshot #6Screenshot #7Screenshot #8Screenshot #9Screenshot #10