how do I consume web service using UTL_DBWS?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: how do I consume web service using UTL_DBWS?

  1. #1
    Join Date
    Dec 2002
    Posts
    5

    how do I consume web service using UTL_DBWS?

    I've been digging around google but unable to find any or working example using this package. Oracle document is not much help in this. I've install all the necessary file to get this running. I just need a little kick start and if some one have use this before, please help. Here is what I am trying to consume.
    This is my first experience with SOAP so please be gentle. Thanks.

    ----sample wdsl---

    -
    Web Service to Authenticate and Manage slb_webservice
    -
    -
    -
    -
    -





    -
    -
    -




    -
    -
    -







    -
    -
    -




    -
    -
    -







    -
    -
    -




    -
    -
    -




    -
    -
    -




    -
    -
    -







    -
    -
    -




    -
    -
    -




    -
    -
    -




    -
    -
    -




    -
    -
    -






    -
    art name="parameters" element="tns:Authenticate" />

    -
    art name="parameters" element="tns:AuthenticateResponse" />

    -
    art name="parameters" element="tns:GetRecord" />

    -
    art name="parameters" element="tns:GetRecordResponse" />

    -
    art name="parameters" element="tns:AddUser" />

    -
    art name="parameters" element="tns:AddUserResponse" />

    -
    art name="parameters" element="tnseleteUser" />

    -
    art name="parameters" element="tnseleteUserResponse" />

    -
    art name="parameters" element="tns:EditUser" />

    -
    art name="parameters" element="tns:EditUserResponse" />

    -
    art name="parameters" element="tns:ReturnName" />

    -
    art name="parameters" element="tns:ReturnNameResponse" />

    -
    art name="parameters" element="tns:ReturnEmail" />

    -
    art name="parameters" element="tns:ReturnEmailResponse" />

    - ortType name="Mini_x0020_PassportSoap">
    - peration name="Authenticate">
    Method to Authenticate slb_webservice

    utput message="tns:AuthenticateSoapOut" />
    peration>
    - peration name="GetRecord">
    Method to response with sqlStr

    utput message="tns:GetRecordSoapOut" />
    peration>
    - peration name="AddUser">
    Method to Add User

    utput message="tns:AddUserSoapOut" />
    peration>
    - peration name="DeleteUser">
    Method to Delete User
    eleteUserSoapIn" />
    utput message="tnseleteUserSoapOut" />
    peration>
    - peration name="EditUser">
    Method to Edit User Information

    utput message="tns:EditUserSoapOut" />
    peration>
    - peration name="ReturnName">
    Method to Obtain User Name

    utput message="tns:ReturnNameSoapOut" />
    peration>
    - peration name="ReturnEmail">
    Method to obtain User Email Address

    utput message="tns:ReturnEmailSoapOut" />
    peration>
    ortType>
    -

    - peration name="Authenticate">
    peration soapAction="sangle/Authenticate" style="document" />
    -


    - utput>

    utput>
    peration>
    - peration name="GetRecord">
    peration soapAction="sangle/GetRecord" style="document" />
    -


    - utput>

    utput>
    peration>
    - peration name="AddUser">
    peration soapAction="sangle/AddUser" style="document" />
    -


    - utput>

    utput>
    peration>
    - peration name="DeleteUser">
    peration soapAction="sangle/DeleteUser" style="document" />
    -


    - utput>

    utput>
    peration>

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220

  3. #3
    Join Date
    Dec 2002
    Posts
    5

    read the article about 10x

    I've been through the article many time and it won't work since the url no longer existed, I've also setup a similar web service but so far unsuccessful. Oracle website is no help so I guess not every one uses this package, I probably have to write a .net instead of using Oracle package.

    Quote Originally Posted by Srinivas_Sharma

  4. #4
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    ok

    well i have not used utl_dbws but able to send a soap request to a .net webservice from pl/sql and get the response back also.

    if you need any help with that let me know

    Srini

  5. #5
    Join Date
    Dec 2002
    Posts
    5

    Srinivas, Could you please help?

    Hi Srinivas, I have a WSDL file, any sample how to consuming would be great. Thanks.
    Attached Files Attached Files
    Last edited by sangle; 02-07-2008 at 08:31 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width