I get this error using PL/SQL to enqueue a JMS message in Oracle XE: Oracle: PLS-00302: component 'CONSTRUCT' must be declared . Following an advice I found on the web , I ran the script "$ORACLE_HOME/rdbms/admin/prvtaqal.plb" as SYS in sqlplus. That worked even though I got a bunch of errors running the script: Warning: Package created with compilation errors. ...

This procedure works for Oracle application server 10.1.3.1, SOA suite. But should be applicable for standalone OC4J or JDeveloper installations with minor modifications. $ORACLE_HOME is the home directory for Oracle app server. $JDEV_HOME is the home directory for JDeveloper. 1. Change directory to $ORACLE_HOME/j2ee , mkdir lib 2. Copy xmlparserv2.jar from $JDEV_HOME to $ORACLE_HOME/j2ee/lib . 3. Copy ocj.jar and jdev_remote.jar from $JDEV_HOME/jdev/lib to $ORACLE_HOME/j2ee/home/lib . 4. Edit global-web-application.xml under your OC4J instance's config directory. Change the development attribute to true . <orion-web-app xmlns:xsi="http://www.w3.org/... 5. Add the following to the servlet section of global-web-application.xml : <servlet> <servlet-name>jsp</servlet-na... 6. Edit $ORACLE_HOME/opmn/conf/opmn.xml , add -Xrunjdwp:transport=dt_socket,server=y,suspend=n,address=4000 to start-parameters/java-options : <process-type id="MYOC4J" module-id="OC4J" status=... 7. In Eclipse, open to port 4000 for remote debugging.

If you use quartz or the plain old java.util.Timer class to schedule jobs in an OC4J container, you need to enable the -userThreads switch with the OC4J container. This is the relevant section in $ORACLE_HOME/opmn/conf/opmn.xml : <process-type id="INST1" module-id="OC4J" status="... Or, you can add it through the Oracle em console. Go to the OC4J container, click "Administration" tab, then "Server Properties". Add "-userThreads" to "Start-parameters: OC4J Options". Debu Panda has written a good article on using quartz in the Oracle environment: Using Quartz Enterprise Scheduler in J2EE

First create a resource provider for Oracle AQ in orion-application.xml: <?xml version = '1.0' encoding = 'windows-1252... Then, hook up the EJB to the queue in orion-ejb-jar.xml: <?xml version = '1.0' encoding = 'windows-1252... Make sure the resource names ('rsname') match among the xml files. Full information is available from the Oracle document titled "Oracle Containers for J2EE Enterprise JavaBeans Developer's Guide 10g (10.1.3.1.0)". Look at Appendix A.