Andrej Koelewijn

4/9/2004

Calling web services using pl/sql in 10g

Filed under: — andrejk @ 11:49 am

Oracle 10g has a new feature to call web services from pl/sql. I did not find a lot of documentation on this. I looks like you can use the utl_dbws package to dynamically consume web services without creating java stubs using jpublish.

I got a no class found exception when using the package. Mike lehmann pointed me to an updated dbws package that fixes this problem. I still can’t get it to work though. I’d be very interested to see an example that uses the utl_dbws package.

4 Responses to “Calling web services using pl/sql in 10g”

  1. Raghu Srinivasan Says:
    November 8th, 2004 at 7:45 pm

    Hi,

    Have you been able to, in these last 6 months, find any sample code on how to consume web services directly from pl/sql in 10g?

    Thanks,

    Raghu

  2. Andrej Says:
    November 8th, 2004 at 8:10 pm

    No, i haven’t spend any more time researching it. Doing mostly java work at the moment, using an oracle 8.1.7 database…

  3. Kirtan Desai Says:
    November 20th, 2006 at 9:34 pm

    Andrej,

    visit the following…

    http://www.oracle.com/technology/tech/webservices/htdocs/samples/dbwebservice/DBWebServices_PLSQL.html

    hope it helps

    Kirtan Desai

  4. Yuan Tschang Says:
    March 20th, 2007 at 2:37 pm

    Here Raghu:

    http://www.oracle-base.com/articles/10g/utl_dbws10g.php

    Haven’t been able to try it, so let me know if it works.

    Yuan

Leave a Reply

Powered by WordPress