te.ins

Oracle PL/SQL procedure generator (second generator type)

INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (322, 'TE', 'TESPEC.GDR', '1', '   [FOREACH]pkycol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (321, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>getupdcol}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (320, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (319, 'TE', 'TESPEC.GDR', '1', '   --// For each update column ... //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (318, 'TE', 'TESPEC.GDR', '1', '[FOREACH]updcol');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (317, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (316, 'TE', 'TESPEC.GDR', '1', '[ENDIF]usecurvar');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (315, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (314, 'TE', 'TESPEC.GDR', '1', '      ;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (313, 'TE', 'TESPEC.GDR', '1', '[ENDIF]      ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (312, 'TE', 'TESPEC.GDR', '1', '         cv_t');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (311, 'TE', 'TESPEC.GDR', '1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (310, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>tableCV}^');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (309, 'TE', 'TESPEC.GDR', '1', '[IF]usestaticSQL');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (308, 'TE', 'TESPEC.GDR', '1', '   RETURN ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (307, 'TE', 'TESPEC.GDR', '1', '      )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (306, 'TE', 'TESPEC.GDR', '1', '   [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (305, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (304, 'TE', 'TESPEC.GDR', '1', '   [FOREACH]uindcol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (303, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>getrowindcv}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (302, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (301, 'TE', 'TESPEC.GDR', '1', '      ;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (300, 'TE', 'TESPEC.GDR', '1', '[ENDIF]      ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (299, 'TE', 'TESPEC.GDR', '1', '      cv_t');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (298, 'TE', 'TESPEC.GDR', '1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (297, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>indexCV}^');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (296, 'TE', 'TESPEC.GDR', '1', '[IF]usestaticSQL');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (295, 'TE', 'TESPEC.GDR', '1', '   RETURN ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (294, 'TE', 'TESPEC.GDR', '1', '      )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (293, 'TE', 'TESPEC.GDR', '1', '   [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (292, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (291, 'TE', 'TESPEC.GDR', '1', '   [FOREACH]pkycol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (290, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>getvalindCV}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (289, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (288, 'TE', 'TESPEC.GDR', '1', '      ;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (287, 'TE', 'TESPEC.GDR', '1', '[ENDIF]      ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (286, 'TE', 'TESPEC.GDR', '1', '         cv_t');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (285, 'TE', 'TESPEC.GDR', '1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (284, 'TE', 'TESPEC.GDR', '1', '         {PLG>pkyCV}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (283, 'TE', 'TESPEC.GDR', '1', '[IF]usestaticSQL');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (282, 'TE', 'TESPEC.GDR', '1', '      RETURN ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (281, 'TE', 'TESPEC.GDR', '1', '      )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (280, 'TE', 'TESPEC.GDR', '1', '   [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (279, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (278, 'TE', 'TESPEC.GDR', '1', '   [FOREACH]uindcol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (277, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>getpkyindCV}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (276, 'TE', 'TESPEC.GDR', '1', '[IF]usecurvar');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (275, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (274, 'TE', 'TESPEC.GDR', '1', '   RETURN {PLG>>tableRT};');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (273, 'TE', 'TESPEC.GDR', '1', '      )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (272, 'TE', 'TESPEC.GDR', '1', '   [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (271, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (270, 'TE', 'TESPEC.GDR', '1', '   [FOREACH]uindcol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (269, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>getrowind}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (268, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (267, 'TE', 'TESPEC.GDR', '1', '   RETURN ^{PLG>indexRT}^;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (266, 'TE', 'TESPEC.GDR', '1', '      )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (265, 'TE', 'TESPEC.GDR', '1', '   [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (264, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (263, 'TE', 'TESPEC.GDR', '1', '   [FOREACH]pkycol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (262, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>getvalind}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (261, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (260, 'TE', 'TESPEC.GDR', '1', '      ;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (259, 'TE', 'TESPEC.GDR', '1', '      RETURN ^{PLG>>pkyRT}^');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (258, 'TE', 'TESPEC.GDR', '1', '      )');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (257, 'TE', 'TESPEC.GDR', '1', '   [ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (256, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (255, 'TE', 'TESPEC.GDR', '1', '   [FOREACH]uindcol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (254, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>getpkyind}^ (');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (253, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (252, 'TE', 'TESPEC.GDR', '1', '   --// For each unique index ... //--');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (251, 'TE', 'TESPEC.GDR', '1', '[FOREACH]uind');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (250, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (249, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (248, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (247, 'TE', 'TESPEC.GDR', '1', '   PRAGMA RESTRICT_REFERENCES (^{PLG>onerowCVfunc}^, {PLG>puritylevels});');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (246, 'TE', 'TESPEC.GDR', '1', '[IF]userestrictref');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (245, 'TE', 'TESPEC.GDR', '1', '[ENDIF]            ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (244, 'TE', 'TESPEC.GDR', '1', '      cv_t;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (243, 'TE', 'TESPEC.GDR', '1', '[ELSE]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (242, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>tableCV}^;');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (241, 'TE', 'TESPEC.GDR', '1', '[IF]usestaticSQL');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (240, 'TE', 'TESPEC.GDR', '1', '   RETURN ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (239, 'TE', 'TESPEC.GDR', '1', '      ) ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (238, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (237, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (236, 'TE', 'TESPEC.GDR', '1', '[FOREACH]pkycol[between],');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (235, 'TE', 'TESPEC.GDR', '1', '   FUNCTION ^{PLG>onerowCVfunc}^ (   ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (234, 'TE', 'TESPEC.GDR', '1', '[IF]usecurvar');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (233, 'TE', 'TESPEC.GDR', '1', '');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (232, 'TE', 'TESPEC.GDR', '1', '[ENDIF]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (231, 'TE', 'TESPEC.GDR', '1', '   PRAGMA RESTRICT_REFERENCES (^{PLG>onerowfunc}^, {PLG>puritylevels});');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (230, 'TE', 'TESPEC.GDR', '1', '[IF]userestrictref');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (229, 'TE', 'TESPEC.GDR', '1', '   RETURN {PLG>>tableRT};');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (228, 'TE', 'TESPEC.GDR', '1', '      ) ');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (227, 'TE', 'TESPEC.GDR', '1', '[ENDFOREACH]');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (226, 'TE', 'TESPEC.GDR', '1', '      ^{PLG>incol}^ IN {PLG>coltype}');
INSERT INTO plg_driver_source (line, driver, name, seq, text) VALUES (225, 'T