There is SOAP-service with the following function:
<?xml version="1.0" encoding="utf-8"?>
<soap12: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">
<soap12:Body>
<TestSecod xmlns="http://10.0.0.254:8088/InvoiceAndPaymentsRegisterService/InternalIandPRegisterService.asmx">
<obTest>
<TextData>string</TextData>
<IntData>int</IntData>
<DateData>dateTime</DateData>
</obTest>
</TestSecod>
</soap12:Body>
</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"('<obTest><TextData>my string</TextData><IntData>314</IntData><DateData>2014-07-24</DateData></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 <. Preview - OK, but now is visible only only < :=(
asked
24 Jul '14, 09:49
Ilia63
1.2k●49●55●78
accept rate:
44%