DBMS_PIPE.RECEIVE_MESSAGE with timeout : DBMS_PIPE « System Packages « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Packages
3. DBMS_PIPE

SQL>
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>
SQL>