Calling J2ee Application from Oracle stored procedure

Discussions

EJB design: Calling J2ee Application from Oracle stored procedure

  1. Hi,

    I want to call a servlet posting a xml from an Oracle stored procedure. Basically the servlet is aprt of a j2ee application following a request response interface. So the stored procedure should be able to post a xml request to servlet and should be capable of receiving back a xml response.

    Please guide me on how to go about this. I am good at java but not on Oracle.

    Thanks
    Sanjeev
  2. Hi,

    There is a concept of External Routines in Oracle.Just have a look this talks about how to call dll/java class from within stored procedures.

    I am not sure how to do this with servlet but you can try atleast.

    Regards,
    Mohit
  3. Hi,

    I found a sample that I think you might find useful.

    http://www.oracle.com/technology/sample_code/tech/java/jsp/samples/wsclient/Readme.html

    Regards

    Waqas
  4. Hi Thanks ,

    quite interesting article.

    Cheers,
    Mohit