Informationssysteme SS20048-17 Stored Procedures in 4GL PL/SQL CREATE PROCEDURE Lager_Auffuellen AS DECLARE...; BEGIN DECLARE CURSOR Knappe_Produkte I
{"Image DocumentName": "Stored Procedures in 4GL PL/SQL", "Image ImageDescription": "CREATE PROCEDURE Lager_Auffuellen AS DECLARE ...; BEGIN DECLARE CURSOR Knappe_Produkte IS SELECT PNr, Vorrat FROM Produkte WHERE Vorrat < 100; KP Knappe_Produkte%ROWTYPE; BEGIN OPEN Knappe_Produkte; LOOP FETCH Knappe_Produkte INTO KP; EXIT WHEN Knappe_Produkte%NOTFOUND; ... IF KP.Vorrat > 10 THEN EXECUTE Nachbestellen (KP.PNr, KP.Vorrat) ELSE EXECUTE Express_Bestellen (KP.PNr, 10); EXECUTE Nachbestellen (KP.PNr, KP.Vorrat - 10); END IF; END LOOP; END; END; Prozedur- deklara- tion. Prozedur- aufruf. EXECUTE Lager_Auffuellen; Informationssysteme SS2004.", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}