SQL>
SQL> CREATE OR REPLACE FUNCTION receive_message (pipe IN VARCHAR2)
2 RETURN VARCHAR2
3 IS
4 stat PLS_INTEGER;
5 retval VARCHAR2(4096);
6 BEGIN
7 stat := DBMS_PIPE.RECEIVE_MESSAGE (pipe, timeout => 10);
8 IF stat = 0
9 THEN
10 DBMS_PIPE.UNPACK_MESSAGE (retval);
11 END IF;
12 RETURN retval;
13 END;
14 /
Warning: Function created with compilation errors.
SQL>
SQL> show error
Errors for FUNCTION RECEIVE_MESSAGE:
LINE/COL ERROR
-------- -----------------------------------------------------------------
7/4 PL/SQL: Statement ignored
7/12 PLS-00201: identifier 'DBMS_PIPE' must be declared
10/7 PL/SQL: Statement ignored
10/7 PLS-00201: identifier 'DBMS_PIPE' must be declared
SQL>