There is SOAP-service with the following function:

&lt?xml version="1.0" encoding="utf-8"?>
&ltsoap12:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap12="http://www.w3.org/2003/05/soap-envelope">
&ltsoap12:Body>
&ltTestSecod xmlns="http://10.0.0.254:8088/InvoiceAndPaymentsRegisterService/InternalIandPRegisterService.asmx">
&ltobTest>
&ltTextData>string&lt/TextData>
&ltIntData>int&lt/IntData>
&ltDateData>dateTime&lt/DateData>
&lt/obTest>
&lt/TestSecod>
&lt/soap12:Body>
&lt/soap12:Envelope>
The WSDLC.exe-compiler (ASA12) generates the following code:
alter function "InternalIandPRegisterService.TestSecod"( / "obTest" _254._0._0._10.InvoiceAndPaymentsRegisterService.InternalIandPRegisterService_asmx.ObjToTest /)
 returns xml
 url 'http://10.0.0.254:8088/InvoiceAndPaymentsRegisterService/InternalIandPRegisterService.asmx'
 type 'SOAP:DOC'
 set 'SOAP(OP=TestSecod)'
 namespace 'http://10.0.0.254:8088/InvoiceAndPaymentsRegisterService/InternalIandPRegisterService.asmx';

Q1: Is it right to change the commented parameter as follows:
alter function "InternalIandPRegisterService.TestSecod"( "obTest" xml)
?
Q2: What should be a request not to receive 400 and 500 error codes? For example: if
SELECT "InternalIandPRegisterService.TestSecod"('&ltobTest>&ltTextData>my string&lt/TextData>&ltIntData>314&lt/IntData>&ltDateData>2014-07-24&lt/DateData>&lt/obTest>');
then
HTTP request failed. Status code '500 Internal Server Error'
SQLCODE=-983, ODBC 3 State="HY000"

P.S. As a 'Left angle brackets', I used &lt. Preview - OK, but now is visible only only &lt :=(

asked 24 Jul '14, 09:49

Ilia63's gravatar image

Ilia63
1.2k515681
accept rate: 44%

edited 24 Jul '14, 09:56

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×438
×19

question asked: 24 Jul '14, 09:49

question was seen: 2,816 times

last updated: 24 Jul '14, 09:56