utPLSQL/documentation/src/prefix.html at version2 · utPLSQL/utPLSQL

55 lines (46 loc) · 1.78 KB

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<head>

</head>

<body>

<h1>Use Non-Default Prefix</h1>

The default prefix for utPLSQL is "ut_", but you don't have to use that

prefix. There are some situations where you absolutely will not want to

use the default prefix. Suppose, for example, that you have written a package

with ten procedures, each of which already have "ut_" as a prefix

(it might stand for "Unified Technologies" or "Underside Treatment: or...well,

you get the picture).

Since this prefix is not hard-coded into utPLSQL, you can very easily

specify your own prefix. You can do this when you run a test, as in:

<pre>

SQL> utPLSQL.test ('te_employee', prefix_in => 'test_');

</pre>

You can also specify a prefix when you add a package to a test suite, as in:

<pre>

SQL> utPackage.add ('mysuite', 'mypackage' prefix_in => 'test_');

</pre>

Of course, when you specify a non-default prefix, you must also build your

test package using that prefix. If you plan to generate a starting point

for your package with utGen, be sure to specify your prefix at that point,

as in:

<pre>

SQL> utGen.testpkg('mypackage' prefix_in => 'test_');

</pre>

For an example of a package with a non-default prefix, check out test_te_employee.pks

and test_te_employee.pkb (Both to be found in the Examples directory of the utPLSQL distribution).

</body>

</html>

Provide feedback