Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2207

Web Service Operation SQL valid in 8.3.2 but invalid in 8.5

XMLWordPrintable

      Compared creating WS from source and view models in 8.3.2 vs 8.5.

      See attached project set

      1) Created WS from ProductsOracle source and WS operations validated fine in 8.3.2 and 8.5 Designer
      2) Created WS from PRoductsViews view model and WS operations contained an error.

      Differences in the SQL for 8.5 vs 8.3.2 relate to the removing the CREATE VIRTUAL PROCEDURE in the SQL.

      8.3.2 SQL

      CREATE VIRTUAL PROCEDURE
BEGIN
	DECLARE string VARIABLES.IN_exampleVar;
	VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
	SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
END

      Same operation validated in 8.5 but results in validation error:

      BEGIN
	DECLARE string VARIABLES.IN_exampleVar;
	VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');
	SELECT * FROM PRoductViews_Output_View.PRoductInfo_OutputView;
END

      ERROR

      ERROR: TEIID30070 The function 'xPathValue(null, '//*[local-name()="exampleName"]')' is a valid function form, but the arguments do not match a known type signature and cannot be converted using implicit type conversions.

        1. testWebService.zip
          36 kB

              parichar@redhat.com Paul Richardson
              blafond Barry LaFond
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: