plw5005.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 24 行

CREATE OR REPLACE FUNCTION no_return (check_in IN BOOLEAN)
   RETURN VARCHAR2
AS
BEGIN
   IF check_in
   THEN
      RETURN 'abc';
   ELSE
      DBMS_OUTPUT.put_line ('Here I am, here I stay');

      IF check_in
      THEN
         RETURN 'def';
      ELSIF SYSDATE IS NOT NULL
      THEN
         RETURN 'qrs';
      ELSE
         DBMS_OUTPUT.put_line ('Hello!');
      END IF;
   END IF;
END no_return;
/

SHOW ERRORS FUNCTION no_return