declare v_pipename varchar2(30):='pipe1'; v_status integer; begin dbms_pipe.pack_message(' hello,this is sending process!'); v_status:=dbms_pipe.send_message(v_pipename); if v_status !=0 then dbms_output.put_line('error!'); end if; end; / 接受进程:
declare v_pipename varchar2(30):='pipe1'; v_status integer; v_msg varchar2(20); begin v_status:=dbms_pipe.receive_message(v_pipename); if v_status !=0 then dbms_output.put_line('error'); end if; dbms_pipe.unpack_message(v_msg); dbms_output.put_line(v_msg); end; / 2. DBMS_ALERT