Hi, I am trying to use "Execute Stored Procedure" however I am no

Ravi Roshan over 8 years ago

Hi,
I am trying to use "Execute Stored Procedure" however I am not able to get the output. There are 2 scenarios I am trying:-
1. If I configured the input as my CDT type then flow breaks and throws error "Invalid Column Type"
2. input type as text and value in XML format, flow is not breaking however I am getting blank output.

Note: I am trying to connect with oracle DB

Discussion posts and replies are publicly visible

Parents

0 harshav over 8 years ago

also please check that Result sets not returned through an OUT parameter can be obtained by naming the ACP resultSet1, resultSet2, etc, depending on which result set is required. MySQL and SQL Server must have result sets returned this way.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 harshav over 8 years ago

also please check that Result sets not returned through an OUT parameter can be obtained by naming the ACP resultSet1, resultSet2, etc, depending on which result set is required. MySQL and SQL Server must have result sets returned this way.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data