SET ECHO ON

-- jezdec m� r�m pro 26" a vidlici pro 26", zkus�m mu p�idat pl᚝ 24"

EXECUTE pridejPlast('Maxxis', 'Ignitor', '2008', 24, 2.5);

anonymous block completed
INSERT INTO pouziva (role11_id_jezdce, role23_vyrobce, role23_model, role23_rok_vyroby)
  VALUES (1, 'Maxxis', 'Ignitor', '2008')

1 rows inserted
ROLLBACK

ROLLBACK succeeded.
-- jezdec m� r�m pro 26" a vidlici pro 26", zkus�m mu p�idat pl᚝ 26"

EXECUTE pridejPlast('Maxxis', 'Ignitor', '2008', 26, 2.5);

anonymous block completed
INSERT INTO pouziva (role11_id_jezdce, role23_vyrobce, role23_model, role23_rok_vyroby)
  VALUES (1, 'Maxxis', 'Ignitor', '2008')

1 rows inserted
ROLLBACK

ROLLBACK succeeded.
-- jezdec m� r�m pro 26" a vidlici pro 24", zkus�m mu p�idat pl᚝ 24"

UPDATE vidlice SET polomer_kola=24
  WHERE ko_vyrobce='Marzocchi' AND ko_model='DirtJumper III' AND ko_rok_vyroby=2004

1 rows updated
EXECUTE pridejPlast('Maxxis', 'Ignitor', '2008', 24, 2.5);

anonymous block completed
INSERT INTO pouziva (role11_id_jezdce, role23_vyrobce, role23_model, role23_rok_vyroby)
  VALUES (1, 'Maxxis', 'Ignitor', '2008')

1 rows inserted
ROLLBACK

ROLLBACK succeeded.
-- jezdec m� r�m pro 26" a vidlici pro 24", zkus�m mu p�idat pl᚝ 27"

UPDATE vidlice SET polomer_kola=24
  WHERE ko_vyrobce='Marzocchi' AND ko_model='DirtJumper III' AND ko_rok_vyroby=2004

1 rows updated
EXECUTE pridejPlast('Maxxis', 'Ignitor', '2008', 27, 2.5);

anonymous block completed
INSERT INTO pouziva (role11_id_jezdce, role23_vyrobce, role23_model, role23_rok_vyroby)
  VALUES (1, 'Maxxis', 'Ignitor', '2008')


Error starting at line 26 in command:
INSERT INTO pouziva (role11_id_jezdce, role23_vyrobce, role23_model, role23_rok_vyroby)
  VALUES (1, 'Maxxis', 'Ignitor', '2008')
Error report:
SQL Error: ORA-20208: Neni mozne pouzivat plast, ktery nepasuje ani do vidlice ani do ramu
ORA-06512: na "HANDLM1.POLOMERYPLASTU", line 18
ORA-04088: chyba během provádění triggeru 'HANDLM1.POLOMERYPLASTU'

ROLLBACK

ROLLBACK succeeded.
-- jezdec m� r�m pro 24" a vidlici pro 26", zkus�m mu p�idat pl᚝ 24"

UPDATE ram SET polomer_kola=24
  WHERE ko_vyrobce='RaceBike' AND ko_model='Bandit DS' AND ko_rok_vyroby=2002

1 rows updated
EXECUTE pridejPlast('Maxxis', 'Ignitor', '2008', 24, 2.5);

anonymous block completed
INSERT INTO pouziva (role11_id_jezdce, role23_vyrobce, role23_model, role23_rok_vyroby)
  VALUES (1, 'Maxxis', 'Ignitor', '2008')

1 rows inserted
ROLLBACK

ROLLBACK succeeded.
