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
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
<html lang="en">
<head>
<title>plsqleditor - 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="browser.html#browser" title="browser">
<link rel="next" href="debugger.html#debugger" title="debugger">
<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="plsqleditor"></a>
<p>
Next: <a rel="next" accesskey="n" href="debugger.html#debugger">debugger</a>,
Previous: <a rel="previous" accesskey="p" href="browser.html#browser">browser</a>,
Up: <a rel="up" accesskey="u" href="tools.html#tools">tools</a>
<hr>
</div>
<h3 class="section">4.3 PL/SQL Editor</h3>
<p><a name="index-PL_002fSQL-Editor-21"></a>
This tool provides you with an advanced editor for developing PL/SQL objects.
<h4 class="subheading">Elements of the editor window</h4>
<p>On the top of the screen is the toolbar for the editor.
<p>Below that are two panes.
The left one "Objects" contains the available objects in the selected schema.
The schema is selectable through the toolbar.
Select the code object you want to edit in this list or start
a new object before starting to edit the code.
<p>The right pane contains more widgets: Contents, Message Log, and the editor itself.
In the Contents list you can find declared methods of packages and also
variables or even anonymous blocks in your code.
Selecting a line in this pane will move the cursor to where the element
is in your code, for instance where a variable or method is declared.
<p>The Message Log contains all errors and optional warnings for given PL/SQL code.
Clicking the log items will take you to the exact place in the editor.
<h4 class="subheading">Toolbar & menu</h4>
<p>The toolbar and menu contain pretty much the same commands with a few exceptions.
<dl>
<dt><strong>Refresh object list</strong><dd> Update the <strong>Object</strong> list to the left of the screen. This is first on the toolbar and close to the end in the menu.
The keyboard shortcut for this is <strong>F5</strong>.
Observe that this list is read from the object cache and will not be updated unless you reread the object cache as well
(Available from the File menu.
<br><dt><strong>Select schema</strong><dd> In the toolbar this is a combobox listing the available schemas. Changing the schema will change the objects displayed in the <strong>Object</strong> list.
Selecting it in the menu (Close to the end) or selecting the <strong>ALT+S</strong> keyboard shortcut will move the keyboard focus to the toolbar combobox.
<br><dt><strong>New sheet</strong><dd> Start editing a new object.
<br><dt><strong>Compile</strong><dd> Compile the current editor. This will compile the procedure with the debug option,
if you don't have the debug options you need to recompile it in order to be able to see watches. The keyboard shortcut for this is <strong>F9</strong>.
<br><dt><strong>Compile with Warnings</strong><dd> Compile the current editor with suggested Oracle's PL/SQL Warnings (PLW). Fixing these warnings can speed up your code.
<br><dt><strong>Static Check</strong><dd> Runs external static checker and displays result along with oracle errors and warnings. This button is only visible if static checker has been set up in preferences.
<br><dt><strong>Next error</strong><dd> Move the cursor to the next syntax error in the current editor. For more information about syntax errors in editors see the editor section.
The keyboard shortcut for this is <strong>CTRL+N</strong>.
<br><dt><strong>Previous error</strong><dd> Move the cursor to the previous syntax error in the current editor. For more information about syntax errors in editors see the editor section.
The keyboard shortcut for this is CTRL+P.
</dl>
<h4 class="subheading">Static check</h4>
<p>Running static check will create a temporary file containing currently open code tab. Then external program will be called with name of temporary file (with full path) given as parameter. Result from that external program should be in specific format in order to be interpreted by TOra.
<p>TOra expects one line of output (written to stdout) to contain one message from static checker. This line should start with number of line followed by semicolon and then text of message.
<p><strong>Note:</strong> in future TOra should be able to interpret linenumber, code of static message and then message itself. Code of static message will be used to open automatically generated URL descibing static checker message.
<p>Example of output from static checker:
<pre class="example"> 72:STC-0100:Comment describing function/procedure and it's parameters is missing
107:STC-0200:Name of procedure "my_procedure" does not comply with naming standard
</pre>
</body></html>
|
