SQL> INSERT INTO osoba VALUES (8,'08-APR-80','Oto','Valek',8004080216,NULL); 1 row created. SQL> UPDATE osoba SET rodne_c=8004080217; UPDATE osoba SET rodne_c=8004080217 * ERROR at line 1: ORA-20201: Spatne rodne cislo ORA-06512: at "VALEKO.RODNE_CISLO", line 2 ORA-04088: error during execution of trigger 'VALEKO.RODNE_CISLO' SQL> SQL> UPDATE ubytovani SET obyvan_mistnost_cislo=202 WHERE ubytovan_osoba_cislo=4; 1 row updated. SQL> UPDATE ubytovani SET obyvan_mistnost_cislo=302 WHERE ubytovan_osoba_cislo=6; UPDATE ubytovani SET obyvan_mistnost_cislo=302 WHERE ubytovan_osoba_cislo=6 * ERROR at line 1: ORA-20202: Kapacita pokoje prekrocena ORA-06512: at "VALEKO.POKOJE_KONTROLA", line 11 ORA-06512: at "VALEKO.KAPACITA_POKOJE1_C", line 2 ORA-04088: error during execution of trigger 'VALEKO.KAPACITA_POKOJE1_C' SQL> UPDATE pokoj SET kapacita=10 WHERE mistnost_cislo=201; 1 row updated. SQL> UPDATE pokoj SET kapacita=2 WHERE mistnost_cislo=302; UPDATE pokoj SET kapacita=2 WHERE mistnost_cislo=302 * ERROR at line 1: ORA-20202: Kapacita pokoje prekrocena ORA-06512: at "VALEKO.POKOJE_KONTROLA", line 11 ORA-06512: at "VALEKO.KAPACITA_POKOJE2_C", line 2 ORA-04088: error during execution of trigger 'VALEKO.KAPACITA_POKOJE2_C' SQL> SQL> UPDATE procedura SET doba='29-MAY-03' WHERE cislo=12; 1 row updated. SQL> UPDATE procedura SET doba='29-MAY-03' WHERE cislo=1; 1 row updated. SQL> UPDATE konani SET realizuje_mistnost_cislo=103 WHERE konana_cislo=12; 0 rows updated. SQL> UPDATE konani SET realizuje_mistnost_cislo=103 WHERE konana_cislo=1; 1 row updated. SQL> SQL> INSERT INTO provedeni_p VALUES (13,5); 1 row created. SQL> INSERT INTO provedeni_p VALUES (12,7); INSERT INTO provedeni_p VALUES (12,7) * ERROR at line 1: ORA-20204: Sestra nema pro tuto proceduru kvalifikaci ORA-06512: at "VALEKO.KVALIFIKACE", line 8 ORA-04088: error during execution of trigger 'VALEKO.KVALIFIKACE' SQL> SQL> INSERT INTO konani VALUES (5,101); 1 row created. SQL> INSERT INTO konani VALUES (8,102); INSERT INTO konani VALUES (8,102) * ERROR at line 1: ORA-20205: Lecebna nema pro proceduru vybaveni ORA-06512: at "VALEKO.VYBAVENI", line 8 ORA-04088: error during execution of trigger 'VALEKO.VYBAVENI' SQL> SQL> UPDATE ubytovani SET obyvan_mistnost_cislo=301 WHERE ubytovan_osoba_cislo=3; 1 row updated. SQL> UPDATE ubytovani SET obyvan_mistnost_cislo=301 WHERE ubytovan_osoba_cislo=1; UPDATE ubytovani SET obyvan_mistnost_cislo=301 WHERE ubytovan_osoba_cislo=1 * ERROR at line 1: ORA-20206: Na pokoji jsou hoste ruzneho pohlavi ORA-06512: at "VALEKO.POHLAVI_KONTROLA", line 14 ORA-06512: at "VALEKO.POHLAVI1_C", line 2 ORA-04088: error during execution of trigger 'VALEKO.POHLAVI1_C' SQL> UPDATE host SET pohlavi=1 WHERE osoba_cislo=6; 1 row updated. SQL> UPDATE host SET pohlavi=0 WHERE osoba_cislo=4; 1 row updated. SQL> UPDATE host SET pohlavi=1 WHERE osoba_cislo=1; UPDATE host SET pohlavi=1 WHERE osoba_cislo=1 * ERROR at line 1: ORA-20206: Na pokoji jsou hoste ruzneho pohlavi ORA-06512: at "VALEKO.POHLAVI_KONTROLA", line 14 ORA-06512: at "VALEKO.POHLAVI2_C", line 2 ORA-04088: error during execution of trigger 'VALEKO.POHLAVI2_C' SQL>