Sample SQL Scripts

3004

I am looking for the sample scripts mentioned in the AQ documenation. These are supposed to be under the directory ORACLE_HOME/demo. I nor anyone else I work with has this directory. Where can I find the scripts? In particular, I am seeking an example of a "blocking dequeue" call.

Thanks in advance
JD

3004

Hi,
The demos are in $ORACLE_HOME/rdbms/demo directory
The PL/SQL demos are aqdemo0*.sql
aqdemo00.sql has detailed description of all demos
The OCI demos are in ociaqdemo*.c
java demos are in aqjmsdemo*.java and aqorademo*.java