Microsoft SQL server adapter - select from a table- valued function with input parameters
in Integration
Summary:
Microsoft SQL server adapter - select from a table- valued function with input parameters
Content (required):
I have some table - valued functions in SQL server DB. a function expects a parameter.
what is the best way to perform the select statement and get the table as a result within OIC?
when I try "run a SQL statement" I get the following error (screenshot #1),
and when I try "Invoke Store Procedure" i do not get the SQL response Whitin mapping. (screenshot#2)
Version (include the version you are using, if applicable):
OIC gen 2
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0