• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1128
  • Last Modified:

How to put a message to JMS vendor from PL/SQL?

Hi,

Does any one has an examples about using PL/SQL to put a message to JMS vendor queue?
My data base is Oracle 8, and JMS vendor is MQSonic.
I know that all is easy using Oracle application server and other Oracle products, bu maybe there is free tricks?

thanks in advance,
Raimondas
0
berniunas
Asked:
berniunas
  • 2
1 Solution
 
annamalai77Commented:
hi there

can u be bit more clear in ur query. if ur asking for auto mailing facility then try the following queries i have. i have not tried using this but this should work for u.

trigger creation
create or replace trigger automail
after insert  on ltm.GIM_ICRR_HDR for each row
DECLARE
 MAIL_FROM  VARCHAR2(50);
 MAIL_TO      VARCHAR2(50);
 SUBJECT    VARCHAR2(50);
 MAILBODY  VARCHAR2(150);
CURSOR cur_email IS
SELECT DISTINCT E_MAIL_NO FROM ltm.PUR_SUPP_MAST
WHERE SUPP_CODE = :NEW.SUPP_CODE;
sup_email  cur_email%ROWTYPE;
Begin
OPEN cur_email;
FETCH cur_email INTO  sup_email;
MAIL_FROM := 'www.LTM.com';
MAIL_TO := sup_email.E_MAIL_NO;
SUBJECT :=' New GRN NO : ' || :NEW.ICRR_NO;
MAILBODY:= 'GRN Details :-  GRN Date is   ' || :NEW.ICRR_DATE ||  '  CRR NO : ' ||
:NEW.CRR_NO || '  SUPPILER NAME :  '  || :NEW.SUPP_NAME;
auto_mail_proc(MAIL_FROM,MAIL_TO,SUBJECT,MAILBODY);
CLOSE cur_email;
End;
/

also go thru the oracle documentation for mailing
regards
annamalai
0
 
berniunasAuthor Commented:
thanks for your answer, but i need not mailing, but i need how to connect to
JMS (java message service) vendor and to put a message into a queue.

thanks again
0
 
annamalai77Commented:
hi there

try the following link from oracle JMS.

http://otn.oracle.com/sample_code/tech/java/jsp/samples/jms/Readme.html

also try this link also

http://www.onjava.com/pub/a/onjava/2001/05/03/jms_primer.html

regards
annamalai
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now