Skip to content

Commit 185faf6

Browse files
DDieterichDDieterich
committed
Final Documentation Update
1 parent 91fc685 commit 185faf6

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

70 files changed

+1678
-2633
lines changed

‎docs/core/DBDocs/index.html

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -3,7 +3,7 @@
33
<FRAMESET cols="20%,80%" title="">
44
<FRAMESET rows="30%,70%" title="">
55
<FRAME src="nodeTypes.html" name="ObjectTypeFrame" title="All Types">
6-
<FRAME src="sequence/index.html" name="DBObjectsFrame" title="All DB Objects">
6+
<FRAME src="table/index.html" name="DBObjectsFrame" title="All DB Objects">
77
</FRAMESET>
88
<FRAME src="" name="ObjectDetailsFrame" title="Database Object details" scrolling="yes">
99
<NOFRAMES>

‎docs/core/DBDocs/nodeTypes.html

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -6,9 +6,9 @@
66
</head>
77
<body id="top_left">
88
<h2>WTP</h2>
9-
<a href="javascript:$n('sequence')" id="sequence">Sequences</a>
109
<a href="javascript:$n('table')" id="table">Tables</a>
1110
<a href="javascript:$n('package')" id="package">Packages</a>
1211
<a href="javascript:$n('package body')" id="package body">Package Bodies</a>
12+
<a href="javascript:$n('sequence')" id="sequence">Sequences</a>
1313

1414
</body> </html>

‎docs/core/DBDocs/package body/WTPLSQL.html

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -69,7 +69,7 @@
6969
</tr>
7070
<tr>
7171
<td>OBJECT_ID</td>
72-
<td>40407</td>
72+
<td>41930</td>
7373
</tr>
7474
<tr>
7575
<td>DATA_OBJECT_ID</td>
@@ -81,15 +81,15 @@
8181
</tr>
8282
<tr>
8383
<td>CREATED</td>
84-
<td>09-JUN-2018&nbsp;11:00:59</td>
84+
<td>29-JUN-2018&nbsp;15:09:15</td>
8585
</tr>
8686
<tr>
8787
<td>LAST_DDL_TIME</td>
88-
<td>09-JUN-2018&nbsp;11:00:59</td>
88+
<td>29-JUN-2018&nbsp;15:21:16</td>
8989
</tr>
9090
<tr>
9191
<td>TIMESTAMP</td>
92-
<td>2018-06-09:11:00:59</td>
92+
<td>2018-06-29:15:21:16</td>
9393
</tr>
9494
<tr>
9595
<td>STATUS</td>

‎docs/core/DBDocs/package body/WT_ASSERT.html

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -69,7 +69,7 @@
6969
</tr>
7070
<tr>
7171
<td>OBJECT_ID</td>
72-
<td>40409</td>
72+
<td>41932</td>
7373
</tr>
7474
<tr>
7575
<td>DATA_OBJECT_ID</td>
@@ -81,15 +81,15 @@
8181
</tr>
8282
<tr>
8383
<td>CREATED</td>
84-
<td>09-JUN-2018&nbsp;11:01:00</td>
84+
<td>29-JUN-2018&nbsp;15:09:16</td>
8585
</tr>
8686
<tr>
8787
<td>LAST_DDL_TIME</td>
88-
<td>09-JUN-2018&nbsp;11:01:00</td>
88+
<td>29-JUN-2018&nbsp;15:21:16</td>
8989
</tr>
9090
<tr>
9191
<td>TIMESTAMP</td>
92-
<td>2018-06-09:11:01:00</td>
92+
<td>2018-06-29:15:21:16</td>
9393
</tr>
9494
<tr>
9595
<td>STATUS</td>

‎docs/core/DBDocs/package body/WT_PROFILER.html

Lines changed: 24 additions & 24 deletions
Original file line numberDiff line numberDiff line change
@@ -69,7 +69,7 @@
6969
</tr>
7070
<tr>
7171
<td>OBJECT_ID</td>
72-
<td>40410</td>
72+
<td>41933</td>
7373
</tr>
7474
<tr>
7575
<td>DATA_OBJECT_ID</td>
@@ -81,15 +81,15 @@
8181
</tr>
8282
<tr>
8383
<td>CREATED</td>
84-
<td>09-JUN-2018&nbsp;11:01:01</td>
84+
<td>29-JUN-2018&nbsp;15:09:17</td>
8585
</tr>
8686
<tr>
8787
<td>LAST_DDL_TIME</td>
88-
<td>09-JUN-2018&nbsp;11:01:01</td>
88+
<td>29-JUN-2018&nbsp;15:21:17</td>
8989
</tr>
9090
<tr>
9191
<td>TIMESTAMP</td>
92-
<td>2018-06-09:11:01:01</td>
92+
<td>2018-06-29:15:21:17</td>
9393
</tr>
9494
<tr>
9595
<td>STATUS</td>
@@ -619,7 +619,7 @@
619619
-- This cursor is used to catch the first occurance of a DBOUT annotation
620620
cursor c_annotation is
621621
select regexp_substr(src.text, C_HEAD_RE||C_MAIN_RE||C_TAIL_RE) TEXT
622-
from all_source src
622+
from dba_source src
623623
where src.owner = USER
624624
and src.name = in_pkg_name
625625
and src.type = 'PACKAGE BODY'
@@ -629,14 +629,14 @@
629629
-- This cursor is used to confirm the PL/SQL source is readable
630630
cursor c_readable is
631631
select *
632-
from all_source src
632+
from dba_source src
633633
where src.owner = g_rec.dbout_owner
634634
and src.name = g_rec.dbout_name
635635
and src.type = g_rec.dbout_type;
636636
b_readable c_readable%ROWTYPE;
637637
-- These hold the positions of the separators dot (.) and colon (:)
638-
l_dot_pos number;
639-
l_cln_pos number;
638+
l_dot_pos number;
639+
l_cln_pos number;
640640
begin
641641
-- Find the first occurance of the DBOUT annotation
642642
open c_annotation;
@@ -663,33 +663,33 @@
663663
-- Locate the Owner/Name separator
664664
l_dot_pos := instr(l_target,'.');
665665
l_cln_pos := instr(l_target,':');
666-
-- Find the matching database object from ALL_OBJECTS
667666
begin
668667
select obj.owner
669668
,obj.object_name
670669
,obj.object_type
671-
into g_rec.dbout_owner
670+
into g_rec.dbout_owner
672671
,g_rec.dbout_name
673672
,g_rec.dbout_type
674-
from all_objects obj
675-
-- No separators were given, assume USER is the owner.
676-
where ( ( l_dot_pos = 0
673+
from dba_objects obj
674+
where ( ( -- No separators were given, assume USER is the owner.
675+
-- No object type was given. This could throw TOO_MANY_ROWS.
676+
l_dot_pos = 0
677677
and l_cln_pos = 0
678678
and obj.owner = USER
679679
and obj.object_name = l_target )
680-
-- No object type was given. This could throw TOO_MANY_ROWS.
681-
OR ( l_dot_pos != 0
680+
OR ( -- No object type was given. This could throw TOO_MANY_ROWS.
681+
l_dot_pos != 0
682682
and l_cln_pos = 0
683683
and obj.owner = substr(l_target, 1, l_dot_pos-1)
684684
and obj.object_name = substr(l_target, l_dot_pos+1, 512) )
685-
-- No object owner was given, assume USER is the owner.
686-
OR ( l_dot_pos = 0
685+
OR ( -- No object owner was given, assume USER is the owner.
686+
l_dot_pos = 0
687687
and l_cln_pos != 0
688688
and obj.owner = USER
689689
and obj.object_name = substr(l_target, 1, l_cln_pos-1)
690690
and obj.object_type = substr(l_target, l_cln_pos+1, 512) )
691-
-- All separators were given
692-
OR ( l_dot_pos != 0
691+
OR ( -- All separators were given
692+
l_dot_pos != 0
693693
and l_cln_pos != 0
694694
and obj.owner = substr(l_target, 1, l_dot_pos-1)
695695
and obj.object_name = substr(l_target, l_dot_pos+1, l_cln_pos-l_dot_pos-1)
@@ -921,7 +921,7 @@
921921
cursor c_find_begin is
922922
select line
923923
,instr(text,'--%WTPLSQL_begin_ignore_lines%--') col
924-
from all_source
924+
from dba_source
925925
where owner = g_rec.dbout_owner
926926
and name = g_rec.dbout_name
927927
and type = g_rec.dbout_type
@@ -932,7 +932,7 @@
932932
with q1 as (
933933
select line
934934
,instr(text,'--%WTPLSQL_end_ignore_lines%--') col
935-
from all_source
935+
from dba_source
936936
where owner = g_rec.dbout_owner
937937
and name = g_rec.dbout_name
938938
and type = g_rec.dbout_type
@@ -960,7 +960,7 @@
960960
then
961961
select max(line)
962962
into buff_find_end.line
963-
from all_source
963+
from dba_source
964964
where owner = g_rec.dbout_owner
965965
and name = g_rec.dbout_name
966966
and type = g_rec.dbout_type;
@@ -1247,7 +1247,7 @@
12471247
join plsql_profiler_data ppd
12481248
on ppd.unit_number = ppu.unit_number
12491249
and ppd.runid = g_rec.prof_runid
1250-
join all_source src
1250+
join dba_source src
12511251
on src.line = ppd.line# + g_rec.trigger_offset
12521252
and src.owner = g_rec.dbout_owner
12531253
and src.name = g_rec.dbout_name
@@ -1876,7 +1876,7 @@
18761876
return 0;
18771877
end if;
18781878
for buff in (
1879-
select line, text from all_source
1879+
select line, text from dba_source
18801880
where owner = dbout_owner_in
18811881
and name = dbout_name_in
18821882
and type = 'TRIGGER'

‎docs/core/DBDocs/package body/WT_PROFILE_INITIALIZE.html

Lines changed: 0 additions & 174 deletions
This file was deleted.

‎docs/core/DBDocs/package body/WT_PROFILE_INITIALIZE/headerBg.jpg

-13.6 KB
Binary file not shown.

0 commit comments

Comments
 (0)