UTL_DBWS – Consuming Web Services…

4 thoughts on “UTL_DBWS – Consuming Web Services…”

1. Hi,

   I am trying to consume a web service using the utl_dbws package. I am getting the following error:

   port: does not contain operation: Envelope
   at oracle.j2ee.ws.client.dii.ConfiguredCall.configureCall(ConfiguredCall.java:154)
   at oracle.j2ee.ws.client.dii.ConfiguredCall.configureCall(ConfiguredCall.java:113)
   at oracle.j2ee.ws.client.dii.ConfiguredCall.setOperationName(ConfiguredCall.java:95)
   at oracle.j2ee.ws.client.dii.BasicCall.directInvoke(BasicCall.java:686)
   at oracle.j2ee.ws.client.dii.BasicCall.invoke(BasicCall.java:598)
   at oracle.jpub.runtime.dbws.DbwsProxy$CallProxy.invokeProxy(Unknown Source)
   at oracle.jpub.runtime.dbws.DbwsProxy$CallProxy.access$2600(Unknown Source)
   at oracle.jpub.runtime.dbws.DbwsProxy.invokeProxy(Unknown Source)
   Internal error – -29532—ORA-29532: Java call terminated by uncaught Java exception: port:does not contain operation: Envelope
   ORA-06512: at “SYS.UTL_DBWS”, line 403
   ORA-06512: at “SYS.UTL_DBWS”, line 400
   ORA-06512: at “my_package_name”, line 622
   16:32:39 Execution finished, retrieved 300 lines, execution time: 2.047 seconds.
   16:32:39 End Executing anonymous block

   This is the way I am making a call:

   l_namespace :=
   ‘http://my url’;
   l_service_qname :=
   SYS.UTL_DBWS.to_qname (l_namespace, ‘myService’);
   l_port_qname :=
   SYS.UTL_DBWS.to_qname (l_namespace, ‘myServiceEndpointPort’);
   l_operation_qname := SYS.UTL_DBWS.to_qname (l_namespace, ‘check’);
   l_service :=
   SYS.UTL_DBWS.create_service
   (wsdl_document_location => urifactory.geturi
   (l_wsdl_url),
   service_name => l_service_qname
   );

   l_call :=
   SYS.UTL_DBWS.create_call (service_handle => l_service,
   port_name => l_port_qname,
   operation_name => l_operation_qname);

   SYS.UTL_DBWS.set_property (l_call, ‘SOAPACTION_USE’, ‘TRUE’);
   SYS.UTL_DBWS.set_property (l_call, ‘SOAPACTION_URI’, ”);
   SYS.utl_dbws.set_property(l_call, ‘OPERATION_STYLE’, ‘DOCUMENT’);

   sys.utl_dbws.set_property(l_call, ‘ENCODINGSTYLE_URI’, ‘http://schemas.xmlsoap.org/soap/encoding/’);

   sys.utl_dbws.to_qname(‘http://www.w3.org/2001/XMLSchema’, ‘string’);
   ws_request_xml :=
   SYS.XMLTYPE.createxml (create_xml (control_nb,
   last_name,
   first_name,
   ssn,
   dob,
   office_cd
   )
   );
   –DBMS_OUTPUT.put_line (ws_request_xml.getstringval);
   ws_response_xml := SYS.UTL_DBWS.invoke (l_call, ws_request_xml);
   DBMS_OUTPUT.put_line (‘3*****************’);
   — call_handle => l_call,
   — input_params => l_input_params);
   SYS.UTL_DBWS.release_call (call_handle => l_call);
   SYS.UTL_DBWS.release_service (service_handle => l_service);
   DBMS_OUTPUT.put_line (ws_response_xml.getstringval);

2. Hi sridevi,

   I am going through your post , i have some questions .. what does the below function do in your post :

   SYS.XMLTYPE.createxml (create_xml (control_nb,
   last_name,
   first_name,
   ssn,
   dob,
   office_cd
   )
   );

   Will it create xml documnet…..

3. It’s not my code. I have no idea what it will do. 🙂

   I assume the “create_xml” function is a custom written function returns some XML, that is then passed to the “XMLTYPE.createxml” function to convert the XML document into an XMLTYPE.

   But as I said, it’s not my code so I have no idea about it.

   Cheers

   Tim…

4. I can’t seem to call this (or any other) web service from Oracle. I get the following error message. (The first couple of lines are in Swedish, and are telling me politely that I have an error and an uncaught java exception). Does anyone know what may be causing this?

   Fel pσ rad 1:
   ORA-29532: Java-anrop avslutades av ouppfσngat Java-undantag:
   java.rmi.RemoteException: java.rmi.RemoteException: ; nested exception is:
   dynamic invocation error: javax.xml.soap.SOAPException: Error parsing envelope
   ORA-06512: vid “SYS.UTL_DBWS”, rad 404
   ORA-06512: vid “SYS.UTL_DBWS”, rad 401
   ORA-06512: vid “PRODPACK.HELLOWORLD”, rad 163

Comments are closed.