te.ins

Oracle PL/SQL procedure generator (second generator type)

SET FEEDBACK OFF
SET DEFINE OFF
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (19, 'TE', 'TEHDR.GDR', '-3', '--//-----------------------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (18, 'TE', 'TEHDR.GDR', '-3', '--//  PL/Generator Version: [plgversion]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (17, 'TE', 'TEHDR.GDR', '-3', '--//  Created By: [thisuser]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (16, 'TE', 'TEHDR.GDR', '-3', '--//  Created On: [rightnow]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (15, 'TE', 'TEHDR.GDR', '-3', '--//  Stored In:  [target]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (14, 'TE', 'TEHDR.GDR', '-3', '--//-----------------------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (13, 'TE', 'TEHDR.GDR', '-3', '--//  For more information, visit www.Quest Software.com or call 1.800.REVEAL4');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (12, 'TE', 'TEHDR.GDR', '-3', '--//');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (11, 'TE', 'TEHDR.GDR', '-3', '--//  This software was generated by Quest Software''s PL/Generator (TM).');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (10, 'TE', 'TEHDR.GDR', '-3', '--//-----------------------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (9, 'TE', 'TEHDR.GDR', '-3', '--//  written permission of [company].');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (8, 'TE', 'TEHDR.GDR', '-3', '--//  or distributed in any form or by any means without the prior');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (7, 'TE', 'TEHDR.GDR', '-3', '--//  No part of this copyrighted work may be reproduced, modified,');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (6, 'TE', 'TEHDR.GDR', '-3', '--//');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (5, 'TE', 'TEHDR.GDR', '-3', '--//               All rights reserved.');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (4, 'TE', 'TEHDR.GDR', '-3', '--//  (c) COPYRIGHT [company] [yearno].');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (3, 'TE', 'TEHDR.GDR', '-3', '--//-----------------------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (2, 'TE', 'TEHDR.GDR', '-3', '--//  ** PL/Generator Table Encapsulator for "[objname]"');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (1, 'TE', 'TEHDR.GDR', '-3', '--//-----------------------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (25, 'TE', 'TEPREP.GDR', '-1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (24, 'TE', 'TEPREP.GDR', '-1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (23, 'TE', 'TEPREP.GDR', '-1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (22, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>puritylevels[TO]WNDS, WNPS');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (21, 'TE', 'TEPREP.GDR', '-1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (20, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>puritylevels[TO]WNDS');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (19, 'TE', 'TEPREP.GDR', '-1', '[IF]loadall[OR]loadincr');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (18, 'TE', 'TEPREP.GDR', '-1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (17, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkycolref[TO]\[colname]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (16, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkgpkyRT[TO]{PLG>tableRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (15, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkyRT[TO]{PLG>tableRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (14, 'TE', 'TEPREP.GDR', '-1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (13, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkycolref[TO]\{PLG>colfld}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (12, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkgpkyRT[TO]{PLG>package}.{PLG>pkyRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (11, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkyRT[TO]{PLG>pkyRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (10, 'TE', 'TEPREP.GDR', '-1', '[IF]havenonpkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (9, 'TE', 'TEPREP.GDR', '-1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (8, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>tabcolref[TO]\[colname]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (7, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkgtableRT[TO]{PLG>tableRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (6, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>tableRT[TO]{PLG>tableRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (5, 'TE', 'TEPREP.GDR', '-1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (4, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>tabcolref[TO]\{PLG>colfld}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (3, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>pkgtableRT[TO]{PLG>package}.{PLG>allcolsRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (2, 'TE', 'TEPREP.GDR', '-1', '   [SETALIAS]PLG>>tableRT[TO]{PLG>allcolsRT}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (1, 'TE', 'TEPREP.GDR', '-1', '[IF]havehidden');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (680, 'TE', 'TESPEC.GDR', '1', '[SPECIAL]mysaextras');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (679, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (678, 'TE', 'TESPEC.GDR', '1', '*/');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (677, 'TE', 'TESPEC.GDR', '1', '||------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (676, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (675, 'TE', 'TESPEC.GDR', '1', '||');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (674, 'TE', 'TESPEC.GDR', '1', '||    Purpose: "[alias_description]"');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (673, 'TE', 'TESPEC.GDR', '1', '||   New name: [new_ident]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (672, 'TE', 'TESPEC.GDR', '1', '|| Invalid: [ident]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (671, 'TE', 'TESPEC.GDR', '1', '[FOREACH]invalid_idents');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (670, 'TE', 'TESPEC.GDR', '1', '||------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (669, 'TE', 'TESPEC.GDR', '1', '|| purpose that code element serves in the package.');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (668, 'TE', 'TESPEC.GDR', '1', '|| used in the code, as well as a description of the');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (667, 'TE', 'TESPEC.GDR', '1', '|| long). It also shows the corrected name that was ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (666, 'TE', 'TESPEC.GDR', '1', '|| were invalid (usually because the names were too');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (665, 'TE', 'TESPEC.GDR', '1', '|| The following list shows those identifiers which ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (664, 'TE', 'TESPEC.GDR', '1', '||------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (663, 'TE', 'TESPEC.GDR', '1', '|| for package {PLG>package} based on [objname]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (662, 'TE', 'TESPEC.GDR', '1', '|| PL/Generator Report on Invalid Identifiers');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (661, 'TE', 'TESPEC.GDR', '1', '||------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (660, 'TE', 'TESPEC.GDR', '1', '/*');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (659, 'TE', 'TESPEC.GDR', '1', '[IF]haveinvalid_idents');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (658, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (657, 'TE', 'TESPEC.GDR', '1', '*/');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (656, 'TE', 'TESPEC.GDR', '1', '|| number.');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (655, 'TE', 'TESPEC.GDR', '1', '|| utilizing the primary key INTEGER column as its row');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (654, 'TE', 'TESPEC.GDR', '1', '|| allowed, since the cache is based on an index-by table');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (653, 'TE', 'TESPEC.GDR', '1', '|| key consisting of more than one column. This is not');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (652, 'TE', 'TESPEC.GDR', '1', '|| You requested caching for a table having a primary');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (651, 'TE', 'TESPEC.GDR', '1', '||------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (650, 'TE', 'TESPEC.GDR', '1', '|| for package {PLG>package} based on [objname]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (649, 'TE', 'TESPEC.GDR', '1', '|| PL/Generator Error Report ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (648, 'TE', 'TESPEC.GDR', '1', '||------------------------------------------------------');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (647, 'TE', 'TESPEC.GDR', '1', '/*');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (646, 'TE', 'TESPEC.GDR', '1', '[IF]loadany[and]multipkycols');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (645, 'TE', 'TESPEC.GDR', '1', '/');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (644, 'TE', 'TESPEC.GDR', '1', 'END {PLG>package};');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (643, 'TE', 'TESPEC.GDR', '1', '[SPECIAL]mypubprograms');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (642, 'TE', 'TESPEC.GDR', '1', '[endif]   ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (641, 'TE', 'TESPEC.GDR', '1', '      ); ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (640, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>inoutend}^ IN INTEGER := NULL');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (639, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>inoutstart}^ IN INTEGER := NULL, ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (638, 'TE', 'TESPEC.GDR', '1', '   PROCEDURE ^{PLG>showloadproc}^ ( ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (637, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (636, 'TE', 'TESPEC.GDR', '1', '   PROCEDURE ^{PLG>loadproc}^;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (635, 'TE', 'TESPEC.GDR', '1', '   --// Load and display index table of data - PK only. //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (634, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (633, 'TE', 'TESPEC.GDR', '1', '[if]loadany[and]onepkycol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (632, 'TE', 'TESPEC.GDR', '1', '   PROCEDURE pinme;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (631, 'TE', 'TESPEC.GDR', '1', '   --// Program called by database initialization script to pin the package. //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (630, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (629, 'TE', 'TESPEC.GDR', '1', '[ENDIF]NOT queryonly');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (628, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (627, 'TE', 'TESPEC.GDR', '1', '      );');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (626, 'TE', 'TESPEC.GDR', '1', '      {PLG>outRC} OUT INTEGER');