Programmatic Environments for Accessing AQ

The following programmatic environments are used to access the Advanced Queuing functions of Oracle8i:

• Native AQ Interface
  • PL/SQL (DBMS_AQADM and DBMS_AQ packages): supports administrative and operational functions

  • C (OCI): supports operational functions

  • Visual Basic (OO4O): supports operational functions

  • Java (oracle.AQ package using JDBC): supports administrative and operational functions

• JMS Interface to AQ
  • Java (javax.jms and oracle.jms packages using JDBC): supports the standard JMS administrative and operational functions and Oracle JMS Extensions

For a comparison of the available functions for these programmatic environments, see the following tables:

• "Comparing AQ Programmatic Environments: Administrative interfaces"

• "Comparing AQ Programmatic Environments: Operational Interfaces"

The AQ programmatic environments and their syntax references are listed in Table 3-1, "AQ Programmatic Environments".

Table 3-1 AQ Programmatic Environments

Language	Precompiler or Interface Program	Syntax Reference	In This Chapter See...
PL/SQL	DBMS_AQADM and DBMS_AQ Package	Oracle8i Supplied PL/SQL Packages Reference	"Using PL/SQL (DBMS_AQADM and DBMS_AQ Packages) to Access AQ""Using PL/SQL (DBMS_AQADM and DBMS_AQ Packages) to Access AQ"
C	Oracle Call Interface (OCI)	Oracle Call Interface Programmer's Guide	"Using OCI to Access AQ")"Using OCI to Access AQ"
Visual Basic	Oracle Objects For OLE (OO4O)	Oracle Objects for OLE (OO4O) is a Windows-based product included with Oracle8i Client for Windows NT. There are no manuals for this product, only online help. Online help is available through the Application Development submenu of the Oracle8i installation.	"Using AQ Java (oracle.AQ) Classes to Access AQ""Using Visual Basic (OO4O) to Access AQ"
Java (AQ)	oracle.AQ package via JDBC Application Programmatic Interface (API)	Oracle8i Supplied Java Packages Reference	"Using AQ Java (oracle.AQ) Classes to Access AQ"
Java (JMS)	oracle.JMS package via JDBC Application Programmatic Interface (API)	Oracle8i Supplied Java Packages Reference	"Using AQ Java (oracle.AQ) Classes to Access AQ""Using Oracle Java Messaging Service (JMS) to Access AQ"