Skip to Main Content

Integration

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Failed to get WSDL service "Text" from WSDL definition

4501Feb 25 2005 — edited Mar 7 2007
Hello,

I am testing User Task BPEL process. All functions correct except for the last service in the BPEL process, the callBackClient process.
This process returns the following error
<bindingFault xmlns="http://schemas.oracle.com/bpel/extension">
<part name="code">GenericError</part>
<part name="summary">Failed get wsdl service definition. Failed to get WSDL service "Text" from WSDL definition "{http://www.demo.com/checkCredibility}Demo". Please verify that WSDL service "Text" is correctly defined in the WSDL file.
</part>
</bindingFault>


Here is the definition of the callBackClient service in the .bpel file

<!-- Callback client asynchronously with response message -->
<invoke name="callbackClient"
partnerLink="client"
portType="tns:DemoCallback"
operation="onResult"
inputVariable="output"
/>

Here the entries in the .wsdl file related to this service, the porttype, message definition and the element (as part of the type definition)

<portType name="DemoCallback">
<operation name="onResult">
<input message="tns:DemoResponseMessage"/>
</operation>
</portType>


<message name="SNTDemoResponseMessage">
<part name="payload" element="tns:DemoResponse"/>
</message>

<element name="DemoResponse">
<complexType>
<sequence>
<element name="company" type="string" />
<element name="person" type="string" />
</sequence>
</complexType>
</element>

What could cause the error Failed to get WSDL service "Text" from WSDL definition?

Thanx in advance
Regards Leon Smiers

Comments

mathguy

It seems to me that you want something like I show below. I am creating a JSON document from a random table (I chose one with a small number of columns, and I limited the row count to 4 to keep the output to a manageable size). The key name ROWSET is hardcoded, but the rest is automatic. Note the use of the wildcard * to stand for "all columns". This can also be used on a view rather than on a table. How you use it on a "cursor" (assuming you need one) I will let you figure out.
Check the documentation for the specific way in which Oracle converts data types from SQL to JSON.
Tested on Oracle 19 on LiveSQL.oracle.com; I only have 12.2 on my machine (on which this obviously fails).

select json_object(key 'ROWSET' value json_arrayagg(json_object(t.*))) as json_str
from   hr.countries t
where  rownum <= 4
;


JSON_STR
---------------------------------
{
"ROWSET" : [
{
"COUNTRY_ID" : "AR",
"COUNTRY_NAME" : "Argentina",
"REGION_ID" : 2
},
{
"COUNTRY_ID" : "AU",
"COUNTRY_NAME" : "Australia",
"REGION_ID" : 3
},
{
"COUNTRY_ID" : "BE",
"COUNTRY_NAME" : "Belgium",
"REGION_ID" : 1
},
{
"COUNTRY_ID" : "BR",
"COUNTRY_NAME" : "Brazil",
"REGION_ID" : 2
}
]
}
Stew Ashton

I don't understand the question. The LiveSQL example produces output with data, whereas you seem to be asking for output that describes the columns. Which is it?

Stew Ashton
Answer

A similar question was asked here:
Is it possible to use JSON SQL functions on a weak ref cursor rather than a table - Ask TOM (0 Bytes)There were two answers:

  1. APEX_JSON
  2. Use native JSON support in Oracle SQL, which requires changing the REF CURSOR itself, or else replacing the REF CURSOR by a named subquery and using a SQL table macro.
    Another approach would be to roll your own generic function: convert the REF CURSOR to a DBMS_SQL cursor, then generate whatever JSON you want.
Marked as Answer by Mike Kutz · Apr 16 2022
Mike Kutz

It looks like APEX_JSON is the tool I'm looking for.
Thanks to both of you.

Mike Kutz

Oh ... Interesting find:
The APEX_JSON trick works on LONG data types (read Data Dictionary)

1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 4 2007
Added on Feb 25 2005
2 comments
828 views