5 Replies Latest reply: Oct 20, 2012 10:09 PM by mdrake-Oracle RSS

    Native web services - Generate proper WSDL file with XSD (XMLType)

    user3982832
      Hello -

      We're using Oracle Native web service. We're using Oracle function to return XMLType in the return message in web service call

      When we generate WSDL file it just shows XMLType and not the XSD with data elements

      How can we generate proper WSDL with XSD

      Here is the SQL we've in the function. We use SQLX functions to generate the XML.

      Appreciate any help

      Line: -----

      SELECT
      XMLElement ("Maharaj",
      XMLAGG(
      XMLELEMENT ("Employee",
      /* XMLAttributes('http://www.oracle.com/emp_simple.xsd' AS "xmlns",
      'http://www.w3.org/2001/XMLSchema-instance' AS "xmlns:xsi",
      'http://www.oracle.com/emp_simple.xsd
      http://www.oracle.com/emp_simple.xsd'
      AS "xsi:schemaLocation"),*/
      XMLForest(e.employee_id AS "EmployeeId",
      e.last_name AS "Name",
      e.job_id AS "Job",
      e.manager_id AS "Manager",
      e.hire_date AS "HireDate",
      e.salary AS "Salary",
      e.commission_pct AS "Commission",
      XMLForest(d.department_id AS "DeptNo",
      d.department_name AS "DeptName",
      d.location_id AS "Location") AS "Dept")
      )
      )
      ) into return_value
      FROM hr.employees e, hr.departments d
      WHERE e.department_id = d.department_id

      Line: -----