|
Comparison of PL/SQL Unit/Code Testing tools
[3021]
Last Modified:
Aug 4, 2009 8:42 AM
This document contains a comparison grid for:
utPLSQL
PL/Unit
PLUTO
dbFit
Quest Code Tester for Oracle
prepared by a "a development manager who has now moved to the process engineering group, which is responsible for defining and implementing process change in the organization."
|
|
|
|
Differences between the freeware and the commercial software
[2792]
Last Modified:
Apr 20, 2009 6:27 PM
Quest Code Tester for Oracle comes in three versions: commercial, trial, and freeware. The commercial and trial versions have identical functionality. The trial version usage is limited to the number of days provided by the trial key. The following
|
|
|
|
Updating the test driver table with results
[2501]
Last Modified:
Dec 22, 2008 9:18 AM
A user recently (November 2008) made this request: he plans to drive his tests from a test data table, but he also wants to record the results of the last test case execution in his table, in addition to the underlying Code Tester tables. We added
|
|
|
|
Testing ETLs: Code Tester in a Data Warehouse environment
[2284]
Last Modified:
Oct 3, 2008 9:49 AM
In a data warehouse environment, ETL (extract, transform and load) is a very common process. And the ETL activities against an Oracle database do not always occur within a PL/SQL code framework.
A developer who recently evaluated Code
|
|
|
|
How to customize assertion code
[2194]
Last Modified:
Aug 25, 2008 2:32 PM
Quest Code Tester generates the test code (a package) that implements the test cases you define in the graphical interface. We would like to offer 100% generated support for every kind of imaginable test, but that is not yet possible.
We
|
|
|
|
Building test definitions for 11g RESULT_CACHE functions
[1951]
Last Modified:
Jun 6, 2008 9:36 AM
Version 1.8.1 of Code Tester now supports 11g. This means for the most part that our data access layer software (Direct Oracle Access from AllroundAutomations) now officially supports 11g.
This is, however, a "gotcha" with this support:
|
|
|
|
Generating tests from test data tables
[1885]
Last Modified:
May 13, 2008 5:15 AM
Quest Code Tester offers a number of different ways to provide values for scalars as both inputs and expected outcomes, including:
• Singleton literal
• Singleton expression or query
• Multiple random values
• Multiple
|
|
|
|
Workaround for CHAR arguments
[1876]
Last Modified:
Apr 30, 2008 2:48 PM
If the procedure being tested has arguments with a CHAR (fixed length) datatype, especially one established through use of the %TYPE attribute, then the results of running your program might be wrong (the input value provided by the user in the
|
|
|
|
Automating the process of configuring the database for tests
[1875]
Last Modified:
Apr 30, 2008 11:12 AM
One of the biggest challenges when testing PL/SQL programs is to set up the various database tables used by those programs with the data needed to run the tests. Code Tester does not yet provide any UI features that will generate the code to set up
|
|
|
|
Troubleshooting problems with Export/Import
[1633]
Last Modified:
Apr 28, 2008 9:00 AM
This document offers advice for overcoming problems you may have when importing a test definition.
|
|
|
|
The Bug Stops Here wallpaper (for monitor and for mobile)
[781]
Last Modified:
Oct 4, 2007 5:58 PM
Need a regular reminder to use Code Tester and get rid of your bugs? Here you go...comes in two sizes: BIG for your desktop/laptop wallpaper and LITTLE for your mobile phone (!).
|
|
|
|
The Helper Package
[612]
Last Modified:
Mar 17, 2008 7:00 AM
The qu_helper package (attached zip file) provides "helper" programs to Quest Support and users to help them make the most of Quest Code Tester, and resolve issues as quickly and easily as possible. The Word document in the zip provides some guidance as to what you can do with both the qu_helper and qu_helper_file packages (the latter is for file-related helper programs).
|
|
|
|
Demonstration script and code for Quest Code Tester
[371]
Last Modified:
Oct 4, 2007 6:00 PM
You will find in this zip three files:
Quick Start Guide for Quest Code Tester for Oracle.doc - a document that takes you step by step through creating test definitions for various scenarios. These mostly reflect the contents of the
|
|
|
|
Challenges and solutions for Oracle PL/SQL code testing
[331]
Last Modified:
Oct 4, 2007 6:01 PM
This white paper reviews the importance of testing code, the state of testing in the software world generally, and the PL/SQL community in particular, and the impact of poorly tested software. We then explore the obstacles to thorough code testing,
|
|
