oracle的訊息簡單示例

===========================================================

oracle的訊息簡單示例

===========================================================

oracle的訊息簡單示例
-- 註冊一個訊息
declare
l_msg long;
l_status number;
begin
dbms_alert.register( 'WAITING' );
for i in 1 .. 999999 loop
dbms_application_info.set_client_info( i );
dbms_alert.waitone( 'WAITING', l_msg, l_status, 0 );
exit when l_status = 0;
for x in ( select * from big_table order by 1, 2, 3, 4 )
loop
null;
end loop;
end loop;
end;
/
exit

-- 通知一個訊息
begin
dbms_alert.signal( 'WAITING', '' );
commit;
end;
/
-- 訊息的收發也可以透過dbms_pipe讀取管道資訊來實現
-- 參考web頁 Oracle資料庫中儲存過程的非同步呼叫