Forum Stats

  • 3,816,532 Users
  • 2,259,202 Discussions
  • 7,893,506 Comments

Discussions

Sample SQL Scripts

3004
3004 Member Posts: 204,171 Green Ribbon
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

Comments

  • 3004
    3004 Member Posts: 204,171 Green Ribbon

    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
This discussion has been closed.