Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
4 subscribers
Views
3209 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
#StoredProcedure Hi, Does anyone know how to pass a table type as par
sathishkumars
over 9 years ago
#StoredProcedure
Hi,
Does anyone know how to pass a table type as parameter to "Execute Stored Procedure" smart service ?
Example:
create type dbo.typeTableTypeTest as table (col_a int, col_b varchar(10))
create table dbo.TableTypeTest (col_a int, col_b varchar(10))
create procedure dbo.spTableTypeTest
(@pintable dbo.typeTableTypeTest READONLY)
AS
BEGIN
INSERT INTO dbo.TableTypeTest (col_a, col_b)
SELECT col_a,col_b FROM @pintable
END
What should be the data type of "pintable" parameter in Appian in above example?
I have tried with "text" and "CDT" but in vain. I get the error:
com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: nvarchar is incompatible with typeTableTypeTest
com.microsoft.sqlserver.jdbc.SQLServerException: The conversion from UNKNOWN to UNKNOWN is unsupported.
OriginalPostID-151280
OriginalPostID-151280
Discussion posts and replies are publicly visible
Parents
0
Cesar Machuca
Appian Employee
over 9 years ago
I recommend you asking in the shared component's news feed. The one for Execute Store Procedure is:
forum.appian.com/.../e-137289
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Cesar Machuca
Appian Employee
over 9 years ago
I recommend you asking in the shared component's news feed. The one for Execute Store Procedure is:
forum.appian.com/.../e-137289
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data