By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create procedure gradeCheck(
grade CHAR
)
IS
BEGIN
IF grade = 'A' THEN
DBMS_OUTPUT.PUT_LINE('Great Work');
ELSE
DBMS_OUTPUT.PUT_LINE('Not great work');
END IF;
END gradeCheck;
/
SELECT *
FROM user_errors;
Begin
DBMS_OUTPUT.PUT_LINE('Initialising buffer');
gradeCheck('A');
end;
/
1 rows affected
dbms_output:
Initialising buffer
Great Work