Another option is to use DBMS_JOB/DBMS_SCHEDULER to call any application that can be activated from the command line. That means if you have a Java program it can be activated from your PL/SQL code.
HTH, Glen Am Montag, den 14.01.2008, 18:47 -0500 schrieb Eric Sammer: > LeeZ01 wrote: > > I need to implement two types of message producers, one is from Java server > > application, the other is from > > PLSQL stored procedures. > > > > I have implemented the Java message senders using ActiveMQ 4.1.1 apis, but I > > need to know how to send messages to the queue from PLSQL. > > > > Any suggestions would be greatly appreciated. > > > > Thanks in advance. > > -Lee > > In theory, you should be able to write a Stomp client in anything that > supports standard socket operations, but I don't believe PL/SQL does > (it's been years since I've touched it). > > As an alternatively, have you considered writing the stored procedures > in question in Java? It's certainly supported in standard Oracle > installs since 8.1.6, give or take. See > http://download.oracle.com/docs/cd/B19306_01/java.102/b14187/chfive.htm#BABGCGBG > > That's from 10g. > Hope that helps and best of luck to you.
