Write a program in PL/SQL to show the uses of SQL%FOUND to determine if a DELETE statement affected any rows.
DROP TABLE student_temp;
CREATE TABLE student_temp AS
SELECT student_id, first_name, last_name
FROM student;
CREATE OR REPLACE PROCEDURE test_proc (
z_stu_id NUMBER
) AUTHID DEFINER AS
BEGIN
DELETE FROM stu_temp
WHERE student_id = z_stu_id;
IF SQL%FOUND THEN
DBMS_OUTPUT.PUT_LINE (
'Delete succeeded for student_id: ' || z_stu_id
);
ELSE
DBMS_OUTPUT.PUT_LINE ('No employee of ID '|| z_stu_id||'is found.');
END IF;
END;
/
BEGIN
test_proc(175);
test_proc(444);
END;
Comments
Leave a comment