Subversion Repositories Sigmater

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
6 Andrea 1 
create or replace procedure CREA_UTENTE_REGIONALE(user_name varchar2,nome varchar2,cognome varchar2,email varchar2) is
2 
 
3 
begin
4 
     -- inserimento utente
5 
     insert into ws_utenti (USERNAME,PASSWORD,
6 
                            COGNOME,NOME,
7 
                            EMAIL,LOGIN,
8 
                            USR_CREATE_DATE,USR_EXPIRATION_DATE)
9 
                 values    (user_name,'7c222fb2927d828af22f592134e8932480637c0d',
10 
                            cognome,nome,
11 
                            email,upper(user_name),
12 
                            sysdate,sysdate);
13 
     -- creazione del profilo
14 
     CREA_RUOLO_PROFILO('COMUNALE',1039,user_name,416);
15 
	   CREA_RUOLO_PROFILO('COMUNALE',1038,user_name,415);
16 
	   CREA_RUOLO_PROFILO('COMUNALE',1037,user_name,414);
17 
	   CREA_RUOLO_PROFILO('COMUNALE',1035,user_name,413);
18 
	   CREA_RUOLO_PROFILO('COMUNALE',1033,user_name,412);
19 
	   CREA_RUOLO_PROFILO('COMUNALE',1030,user_name,411);
20 
	   CREA_RUOLO_PROFILO('COMUNALE',1028,user_name,410);
21 
	   CREA_RUOLO_PROFILO('COMUNALE',1026,user_name,409);
22 
	   CREA_RUOLO_PROFILO('COMUNALE',1023,user_name,408);
23 
	   CREA_RUOLO_PROFILO('COMUNALE',1020,user_name,407);
24 
	   CREA_RUOLO_PROFILO('COMUNALE',1017,user_name,406);
25 
	   CREA_RUOLO_PROFILO('COMUNALE',1014,user_name,405);
26 
	   CREA_RUOLO_PROFILO('COMUNALE',1011,user_name,404);
27 
     CREA_RUOLO_PROFILO('COMUNALE',1008,user_name,403);
28 
	   CREA_RUOLO_PROFILO('COMUNALE',1006,user_name,402);
29 
	   CREA_RUOLO_PROFILO('COMUNALE',1005,user_name,401);
30 
	   CREA_RUOLO_PROFILO('COMUNALE',1000,user_name,400);
31 
/*    -- inserisco l'abilitazione  */
32 
     insert into ws_cross_enti_utenti values(user_name,1704);
33 
      insert into ws_cross_enti_utenti values(user_name,1705);
34 
      insert into ws_cross_enti_utenti values(user_name,1706);
35 
      insert into ws_cross_enti_utenti values(user_name,1707);
36 
      insert into ws_cross_enti_utenti values(user_name,1708);
37 
      insert into ws_cross_enti_utenti values(user_name,1709);
38 
      insert into ws_cross_enti_utenti values(user_name,1710);
39 
      insert into ws_cross_enti_utenti values(user_name,1711);
40 
      insert into ws_cross_enti_utenti values(user_name,1712);
41 
      insert into ws_cross_enti_utenti values(user_name,1713);
42 
      insert into ws_cross_enti_utenti values(user_name,1714);
43 
      insert into ws_cross_enti_utenti values(user_name,1715);
44 
      insert into ws_cross_enti_utenti values(user_name,1716);
45 
      insert into ws_cross_enti_utenti values(user_name,1717);
46 
      insert into ws_cross_enti_utenti values(user_name,1718);
47 
      insert into ws_cross_enti_utenti values(user_name,1719);
48 
      insert into ws_cross_enti_utenti values(user_name,1720);
49 
      insert into ws_cross_enti_utenti values(user_name,1721);
50 
      insert into ws_cross_enti_utenti values(user_name,1722);
51 
      insert into ws_cross_enti_utenti values(user_name,1723);
52 
      insert into ws_cross_enti_utenti values(user_name,1724);
53 
      insert into ws_cross_enti_utenti values(user_name,1725);
54 
      insert into ws_cross_enti_utenti values(user_name,1726);
55 
      insert into ws_cross_enti_utenti values(user_name,1727);
56 
      insert into ws_cross_enti_utenti values(user_name,1728);
57 
      insert into ws_cross_enti_utenti values(user_name,1729);
58 
      insert into ws_cross_enti_utenti values(user_name,1730);
59 
      insert into ws_cross_enti_utenti values(user_name,1731);
60 
      insert into ws_cross_enti_utenti values(user_name,1732);
61 
      insert into ws_cross_enti_utenti values(user_name,1733);
62 
      insert into ws_cross_enti_utenti values(user_name,1734);
63 
      insert into ws_cross_enti_utenti values(user_name,1735);
64 
      insert into ws_cross_enti_utenti values(user_name,1736);
65 
      insert into ws_cross_enti_utenti values(user_name,1737);
66 
      insert into ws_cross_enti_utenti values(user_name,1738);
67 
      insert into ws_cross_enti_utenti values(user_name,1739);
68 
      insert into ws_cross_enti_utenti values(user_name,1740);
69 
      insert into ws_cross_enti_utenti values(user_name,1741);
70 
      insert into ws_cross_enti_utenti values(user_name,1742);
71 
      insert into ws_cross_enti_utenti values(user_name,1743);
72 
      insert into ws_cross_enti_utenti values(user_name,1744);
73 
      insert into ws_cross_enti_utenti values(user_name,1745);
74 
      insert into ws_cross_enti_utenti values(user_name,1746);
75 
      insert into ws_cross_enti_utenti values(user_name,1747);
76 
      insert into ws_cross_enti_utenti values(user_name,1748);
77 
      insert into ws_cross_enti_utenti values(user_name,1749);
78 
      insert into ws_cross_enti_utenti values(user_name,1750);
79 
      insert into ws_cross_enti_utenti values(user_name,1751);
80 
      insert into ws_cross_enti_utenti values(user_name,1752);
81 
      insert into ws_cross_enti_utenti values(user_name,1753);
82 
      insert into ws_cross_enti_utenti values(user_name,1754);
83 
      insert into ws_cross_enti_utenti values(user_name,1755);
84 
      insert into ws_cross_enti_utenti values(user_name,1756);
85 
      insert into ws_cross_enti_utenti values(user_name,1757);
86 
      insert into ws_cross_enti_utenti values(user_name,1758);
87 
      insert into ws_cross_enti_utenti values(user_name,1759);
88 
      insert into ws_cross_enti_utenti values(user_name,1760);
89 
      insert into ws_cross_enti_utenti values(user_name,1761);
90 
      insert into ws_cross_enti_utenti values(user_name,1762);
91 
      insert into ws_cross_enti_utenti values(user_name,1763);
92 
      insert into ws_cross_enti_utenti values(user_name,1764);
93 
      insert into ws_cross_enti_utenti values(user_name,1765);
94 
      insert into ws_cross_enti_utenti values(user_name,1766);
95 
      insert into ws_cross_enti_utenti values(user_name,1767);
96 
      insert into ws_cross_enti_utenti values(user_name,1768);
97 
      insert into ws_cross_enti_utenti values(user_name,1769);
98 
      insert into ws_cross_enti_utenti values(user_name,1770);
99 
      --insert into ws_cross_enti_utenti values(user_name,1771);
100 
      insert into ws_cross_enti_utenti values(user_name,1772);
101 
      insert into ws_cross_enti_utenti values(user_name,1871);
102 
      insert into ws_cross_enti_utenti values(user_name,1872);
103 
      insert into ws_cross_enti_utenti values(user_name,1873);
104 
      insert into ws_cross_enti_utenti values(user_name,1874);
105 
      insert into ws_cross_enti_utenti values(user_name,1875);
106 
      insert into ws_cross_enti_utenti values(user_name,1876);
107 
      insert into ws_cross_enti_utenti values(user_name,1877);
108 
      insert into ws_cross_enti_utenti values(user_name,1878);
109 
      insert into ws_cross_enti_utenti values(user_name,1879);
110 
      insert into ws_cross_enti_utenti values(user_name,1880);
111 
      insert into ws_cross_enti_utenti values(user_name,1881);
112 
      insert into ws_cross_enti_utenti values(user_name,1882);
113 
      insert into ws_cross_enti_utenti values(user_name,1883);
114 
      insert into ws_cross_enti_utenti values(user_name,1884);
115 
      insert into ws_cross_enti_utenti values(user_name,1885);
116 
      insert into ws_cross_enti_utenti values(user_name,1886);
117 
      insert into ws_cross_enti_utenti values(user_name,1887);
118 
      insert into ws_cross_enti_utenti values(user_name,1888);
119 
      insert into ws_cross_enti_utenti values(user_name,1889);
120 
      insert into ws_cross_enti_utenti values(user_name,1890);
121 
      insert into ws_cross_enti_utenti values(user_name,1891);
122 
      insert into ws_cross_enti_utenti values(user_name,1892);
123 
      insert into ws_cross_enti_utenti values(user_name,1893);
124 
      insert into ws_cross_enti_utenti values(user_name,1894);
125 
      insert into ws_cross_enti_utenti values(user_name,1895);
126 
      insert into ws_cross_enti_utenti values(user_name,1896);
127 
      insert into ws_cross_enti_utenti values(user_name,1897);
128 
      insert into ws_cross_enti_utenti values(user_name,1898);
129 
      insert into ws_cross_enti_utenti values(user_name,1899);
130 
      insert into ws_cross_enti_utenti values(user_name,1900);
131 
      insert into ws_cross_enti_utenti values(user_name,1901);
132 
      insert into ws_cross_enti_utenti values(user_name,1902);
133 
      insert into ws_cross_enti_utenti values(user_name,1903);
134 
      insert into ws_cross_enti_utenti values(user_name,1904);
135 
      insert into ws_cross_enti_utenti values(user_name,1905);
136 
      insert into ws_cross_enti_utenti values(user_name,1906);
137 
      insert into ws_cross_enti_utenti values(user_name,1907);
138 
      insert into ws_cross_enti_utenti values(user_name,1908);
139 
      insert into ws_cross_enti_utenti values(user_name,1909);
140 
      insert into ws_cross_enti_utenti values(user_name,1910);
141 
      insert into ws_cross_enti_utenti values(user_name,1911);
142 
      insert into ws_cross_enti_utenti values(user_name,1912);
143 
      insert into ws_cross_enti_utenti values(user_name,1913);
144 
      insert into ws_cross_enti_utenti values(user_name,1914);
145 
      insert into ws_cross_enti_utenti values(user_name,1915);
146 
      insert into ws_cross_enti_utenti values(user_name,1916);
147 
      insert into ws_cross_enti_utenti values(user_name,1917);
148 
      insert into ws_cross_enti_utenti values(user_name,1918);
149 
      insert into ws_cross_enti_utenti values(user_name,1919);
150 
      insert into ws_cross_enti_utenti values(user_name,1920);
151 
      insert into ws_cross_enti_utenti values(user_name,1921);
152 
      insert into ws_cross_enti_utenti values(user_name,1922);
153 
      insert into ws_cross_enti_utenti values(user_name,1923);
154 
      insert into ws_cross_enti_utenti values(user_name,1924);
155 
      insert into ws_cross_enti_utenti values(user_name,1925);
156 
      insert into ws_cross_enti_utenti values(user_name,1926);
157 
      insert into ws_cross_enti_utenti values(user_name,1927);
158 
      insert into ws_cross_enti_utenti values(user_name,1928);
159 
      insert into ws_cross_enti_utenti values(user_name,1929);
160 
      insert into ws_cross_enti_utenti values(user_name,1930);
161 
      insert into ws_cross_enti_utenti values(user_name,1931);
162 
      insert into ws_cross_enti_utenti values(user_name,1932);
163 
      insert into ws_cross_enti_utenti values(user_name,1933);
164 
      insert into ws_cross_enti_utenti values(user_name,1934);
165 
      insert into ws_cross_enti_utenti values(user_name,1935);
166 
      insert into ws_cross_enti_utenti values(user_name,1936);
167 
      insert into ws_cross_enti_utenti values(user_name,1937);
168 
      insert into ws_cross_enti_utenti values(user_name,1938);
169 
      insert into ws_cross_enti_utenti values(user_name,1939);
170 
      insert into ws_cross_enti_utenti values(user_name,1839);
171 
      insert into ws_cross_enti_utenti values(user_name,1840);
172 
      insert into ws_cross_enti_utenti values(user_name,1841);
173 
      insert into ws_cross_enti_utenti values(user_name,1842);
174 
      insert into ws_cross_enti_utenti values(user_name,1843);
175 
      insert into ws_cross_enti_utenti values(user_name,1844);
176 
      insert into ws_cross_enti_utenti values(user_name,1845);
177 
      insert into ws_cross_enti_utenti values(user_name,1846);
178 
      insert into ws_cross_enti_utenti values(user_name,1847);
179 
      insert into ws_cross_enti_utenti values(user_name,1848);
180 
      insert into ws_cross_enti_utenti values(user_name,1849);
181 
      insert into ws_cross_enti_utenti values(user_name,1850);
182 
      insert into ws_cross_enti_utenti values(user_name,1851);
183 
      insert into ws_cross_enti_utenti values(user_name,1852);
184 
      insert into ws_cross_enti_utenti values(user_name,1853);
185 
      insert into ws_cross_enti_utenti values(user_name,1854);
186 
      insert into ws_cross_enti_utenti values(user_name,1855);
187 
      insert into ws_cross_enti_utenti values(user_name,1856);
188 
      insert into ws_cross_enti_utenti values(user_name,1857);
189 
      insert into ws_cross_enti_utenti values(user_name,1858);
190 
      insert into ws_cross_enti_utenti values(user_name,1859);
191 
      insert into ws_cross_enti_utenti values(user_name,1860);
192 
      insert into ws_cross_enti_utenti values(user_name,1861);
193 
      insert into ws_cross_enti_utenti values(user_name,1862);
194 
      insert into ws_cross_enti_utenti values(user_name,1863);
195 
      insert into ws_cross_enti_utenti values(user_name,1864);
196 
      insert into ws_cross_enti_utenti values(user_name,1865);
197 
      insert into ws_cross_enti_utenti values(user_name,1866);
198 
      insert into ws_cross_enti_utenti values(user_name,1867);
199 
      insert into ws_cross_enti_utenti values(user_name,1868);
200 
      insert into ws_cross_enti_utenti values(user_name,1869);
201 
      insert into ws_cross_enti_utenti values(user_name,1870);
202 
      -- insert into ws_cross_enti_utenti values(user_name,1772);
203 
      insert into ws_cross_enti_utenti values(user_name,1773);
204 
      insert into ws_cross_enti_utenti values(user_name,1774);
205 
      insert into ws_cross_enti_utenti values(user_name,1775);
206 
      insert into ws_cross_enti_utenti values(user_name,1776);
207 
      insert into ws_cross_enti_utenti values(user_name,1777);
208 
      insert into ws_cross_enti_utenti values(user_name,1778);
209 
      insert into ws_cross_enti_utenti values(user_name,1779);
210 
      insert into ws_cross_enti_utenti values(user_name,1780);
211 
      insert into ws_cross_enti_utenti values(user_name,1781);
212 
      insert into ws_cross_enti_utenti values(user_name,1782);
213 
      insert into ws_cross_enti_utenti values(user_name,1783);
214 
      insert into ws_cross_enti_utenti values(user_name,1784);
215 
      insert into ws_cross_enti_utenti values(user_name,1785);
216 
      insert into ws_cross_enti_utenti values(user_name,1786);
217 
      insert into ws_cross_enti_utenti values(user_name,1787);
218 
      insert into ws_cross_enti_utenti values(user_name,1788);
219 
      insert into ws_cross_enti_utenti values(user_name,1789);
220 
      insert into ws_cross_enti_utenti values(user_name,1790);
221 
      insert into ws_cross_enti_utenti values(user_name,1791);
222 
      insert into ws_cross_enti_utenti values(user_name,1792);
223 
      insert into ws_cross_enti_utenti values(user_name,1793);
224 
      insert into ws_cross_enti_utenti values(user_name,1794);
225 
      insert into ws_cross_enti_utenti values(user_name,1795);
226 
      insert into ws_cross_enti_utenti values(user_name,1796);
227 
      insert into ws_cross_enti_utenti values(user_name,1797);
228 
      insert into ws_cross_enti_utenti values(user_name,1798);
229 
      insert into ws_cross_enti_utenti values(user_name,1799);
230 
      insert into ws_cross_enti_utenti values(user_name,1800);
231 
      insert into ws_cross_enti_utenti values(user_name,1801);
232 
      insert into ws_cross_enti_utenti values(user_name,1802);
233 
      insert into ws_cross_enti_utenti values(user_name,1803);
234 
      insert into ws_cross_enti_utenti values(user_name,1804);
235 
      insert into ws_cross_enti_utenti values(user_name,1805);
236 
      insert into ws_cross_enti_utenti values(user_name,1806);
237 
      insert into ws_cross_enti_utenti values(user_name,1807);
238 
      insert into ws_cross_enti_utenti values(user_name,1808);
239 
      insert into ws_cross_enti_utenti values(user_name,1809);
240 
      insert into ws_cross_enti_utenti values(user_name,1810);
241 
      insert into ws_cross_enti_utenti values(user_name,1811);
242 
      insert into ws_cross_enti_utenti values(user_name,1812);
243 
      insert into ws_cross_enti_utenti values(user_name,1813);
244 
      insert into ws_cross_enti_utenti values(user_name,1814);
245 
      insert into ws_cross_enti_utenti values(user_name,1815);
246 
      insert into ws_cross_enti_utenti values(user_name,1816);
247 
      insert into ws_cross_enti_utenti values(user_name,1817);
248 
      insert into ws_cross_enti_utenti values(user_name,1818);
249 
      insert into ws_cross_enti_utenti values(user_name,1819);
250 
      insert into ws_cross_enti_utenti values(user_name,1820);
251 
      insert into ws_cross_enti_utenti values(user_name,1821);
252 
      insert into ws_cross_enti_utenti values(user_name,1822);
253 
      insert into ws_cross_enti_utenti values(user_name,1823);
254 
      insert into ws_cross_enti_utenti values(user_name,1824);
255 
      insert into ws_cross_enti_utenti values(user_name,1825);
256 
      insert into ws_cross_enti_utenti values(user_name,1826);
257 
      insert into ws_cross_enti_utenti values(user_name,1827);
258 
      insert into ws_cross_enti_utenti values(user_name,1828);
259 
      insert into ws_cross_enti_utenti values(user_name,1829);
260 
      insert into ws_cross_enti_utenti values(user_name,1830);
261 
      insert into ws_cross_enti_utenti values(user_name,1831);
262 
      insert into ws_cross_enti_utenti values(user_name,1832);
263 
      insert into ws_cross_enti_utenti values(user_name,1833);
264 
      insert into ws_cross_enti_utenti values(user_name,1834);
265 
      insert into ws_cross_enti_utenti values(user_name,1835);
266 
      insert into ws_cross_enti_utenti values(user_name,1836);
267 
      insert into ws_cross_enti_utenti values(user_name,1837);
268 
      insert into ws_cross_enti_utenti values(user_name,1838);
269 
     commit;
270 
exception
271 
          when others then
272 
               dbms_output.put_line('ERR INS utente '|| sqlcode ||' '||sqlerrm);
273 
               rollback;
274 
end CREA_UTENTE_REGIONALE;
275 
/
276