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. -- Eric Sammer System Architect CheetahMail, an Experian Company +1.212.863.4642 - [EMAIL PROTECTED]
