File: dbms_alert_session_C.sql

package info (click to toggle)
orafce 3.0.7-4
  • links: PTS, VCS
  • area: main
  • in suites: jessie, jessie-kfreebsd
  • size: 1,144 kB
  • ctags: 1,068
  • sloc: ansic: 7,504; sql: 5,841; lex: 1,040; makefile: 93; yacc: 80; sh: 9
file content (15 lines) | stat: -rw-r--r-- 285 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 
\set ECHO all

/* Register alerts */
SELECT dbms_alert.register('a1');
SELECT dbms_alert.register('a2');

/* Test: multisession waitone */
SELECT dbms_alert.waitone('a1',2);

/* Test: multisession waitany */
SELECT dbms_alert.waitany(2);

/* cleanup */
SELECT dbms_alert.removeall();