SQL> SET ECHO ON
SQL> SET SERVEROUTPUT ON SIZE 1000000
SQL>
SQL>
SQL> DECLARE
2
3
4 returnValue INTEGER;
5
6
7 FUNCTION get_user
8 RETURN VARCHAR2 IS
9
10 BEGIN
11
12
13 FOR i IN (SELECT user FROM dual) LOOP
14 return i.user;
15 END LOOP;
16
17 END get_user;
18
19 BEGIN
20
21
22 returnValue := DBMS_PIPE.REMOVE_PIPE(get_user||'$'||'MESSAGE_INBOX');
23 returnValue := DBMS_PIPE.REMOVE_PIPE(get_user||'$'||'MESSAGE_OUTBOX');
24
25 END;
26 /
PL/SQL procedure successfully completed.
|