Details
-
Feature Request
-
Resolution: Done
-
Major
-
8.1
-
None
Description
Ex:
CREATE VIRTUAL PROCEDURE
BEGIN
SELECT
XMLELEMENT(NAME "soap:Envelope", XMLNAMESPACES('http://schemas.xmlsoap.org/soap/envelope/' AS soap, DEFAULT 'http://otda.ny.gov/intake/caseinqwsdl/1_0', DEFAULT 'http://otda.ny.gov/intake/caseinquiryin/1_0'), XMLELEMENT(NAME "soap:Header"), XMLELEMENT(NAME "soap:Body", XMLELEMENT(NAME CaseInquiry, XMLELEMENT(NAME CaseNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.CaseNumber), XMLELEMENT(NAME DistrictNumber, XMLNAMESPACES(NO DEFAULT), NYCWMSServiceView.CaseInquiry_request.DistrictNumber)))) AS
xml_out;
END
ERROR: At most only one NO DEFAULT or DEFAULT namespace may be specified.