1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
<html lang="en">
<head>
<title>unittest - TOra</title>
<meta http-equiv="Content-Type" content="text/html">
<meta name="description" content="TOra">
<meta name="generator" content="makeinfo 4.13">
<link title="Top" rel="start" href="index.html#Top">
<link rel="up" href="tools.html#tools" title="tools">
<link rel="prev" href="debugger.html#debugger" title="debugger">
<link rel="next" href="tuning.html#tuning" title="tuning">
<link href="http://www.gnu.org/software/texinfo/" rel="generator-home" title="Texinfo Homepage">
<!--
This manual is for TOra, version 2.1.2+.-->
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css"><!--
pre.display { font-family:inherit }
pre.format { font-family:inherit }
pre.smalldisplay { font-family:inherit; font-size:smaller }
pre.smallformat { font-family:inherit; font-size:smaller }
pre.smallexample { font-size:smaller }
pre.smalllisp { font-size:smaller }
span.sc { font-variant:small-caps }
span.roman { font-family:serif; font-weight:normal; }
span.sansserif { font-family:sans-serif; font-weight:normal; }
--></style>
</head>
<body>
<div class="node">
<a name="unittest"></a>
<p>
Next: <a rel="next" accesskey="n" href="tuning.html#tuning">tuning</a>,
Previous: <a rel="previous" accesskey="p" href="debugger.html#debugger">debugger</a>,
Up: <a rel="up" accesskey="u" href="tools.html#tools">tools</a>
<hr>
</div>
<h3 class="section">4.5 PL/SQL Unit Tester</h3>
<p><a name="index-PL_002fSQL-Unit-Tester-23"></a>
This tool allows you to run procedures, functions,
and package members independently. Selecting proper
PL/SQL unit will result in anonymous PL/SQL block
containing given unit and an environment with
setting variables and required outputs with unit
results (via DBMS_OUTPUT).
<p>Automatically created code blocks can be modified
by user.
<p>What is the Unit Test Script? The anonymous PL/SQL block with the following
structure:
<pre class="example"> DECLARE
-- declarations of IN/OUT parameters
foo number;
bar varchar2(22);
BEGIN
-- definitions of parameters
foo := 1;
bar := 2;
-- calling requested unit
MYOWN.COOLPACKAGE.FOOBAR(
foo => foo,
bar => bar
);
-- printing of the results
sys.dbms_output.put_line('foo: ' || foo);
sys.dbms_output.put_line('bar: ' || bar);
END;
</pre>
<p>It can handle only basic data types currently.
No PLSQLdata (record of etc.) supported yet.
</body></html>
|