Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to call a webservice from pl/sql

User_H6M8AJun 20 2019 — edited Jun 21 2019

Hello gurus,

I have a SOAP wsdl :

/***********************************************************************************************************************************************************************/

<?xml version="1.0" encoding="UTF-8"?>

<definitions targetNamespace="urn:enterprise.soap.sforce.com"

             xmlns="http://schemas.xmlsoap.org/wsdl/"

             xmlns:soap="http://schemas.xmlsoap.org/wsdl/soap/"

             xmlns:xsd="http://www.w3.org/2001/XMLSchema"

             xmlns:tns="urn:enterprise.soap.sforce.com"

             xmlns:fns="urn:fault.enterprise.soap.sforce.com"

             xmlns:ens="urn:sobject.enterprise.soap.sforce.com">

    <types>

        <schema elementFormDefault="qualified" xmlns="http://www.w3.org/2001/XMLSchema" targetNamespace="urn:sobject.enterprise.soap.sforce.com">

          <import namespace="urn:enterprise.soap.sforce.com"/>   

            <!-- Login Message Types -->

            <element name="login">

                <complexType>

                    <sequence>

                        <element name="username" type="xsd:string"/>

                        <element name="password" type="xsd:string"/>

                    </sequence>

                </complexType>

            </element>

            <element name="loginResponse">

                <complexType>

                    <sequence>

                        <element name="result" type="tns:LoginResult"/>

                    </sequence>

                </complexType>

            </element>

</definitions>

/***********************************************************************************************************************************************************************/

Here’s the API user information to consume the web service

  • API username: test@testcom.stage
  • Security token (case-sensitive): GHKJKKLKLSADLASDJ

   

   i need to call the Login() service, passing it a username and security token  to get a valid session ID.

Please can you let me know how to proceed with the above approach

Comments
Post Details
Added on Jun 20 2019
7 comments
6,144 views