Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
calling tMySqlSP gives the above output in newColumn.
Sproc:
CREATE DEFINER=`root`@`localhost` PROCEDURE `my_proc`() begin declare a int default 10; select a; end
Talend Job:
Output:
.--------------------------------------. | tLogRow_1 | |=------------------------------------=| |newColumn | |=------------------------------------=| |com.mysql.jdbc.JDBC4ResultSet@13deb50e| '--------------------------------------'
I am trying out the component and want to display the value of `a`. (The sproc works fine in MySQL)
Please help!
Hello,
The Input parameters is to be returned as a set of values, rather than single value when you choose RECORDSET type.
Best regards
Sabrina